You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Fetching single latest row per person in logical SQL

Received Response
76
Views
9
Comments
edited Jul 3, 2020 8:37AM in Reporting and Analytics for HCM 9 comments

Summary

Fetching single latest row per person in logical SQL

Content

Hi Team,

I need to fetch Top row for a person and am using assignment real time subject area.. But, its fetching more than single rows based on different assignment number, assignment start date. I need to fetch single row per person. I tried using Rcount, topn, rank... but Nothing working properly and these are behaving different for different fields and orders.

Any idea how to fetch single row person that should be latest one. 

Attached sample data.

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!