Skip to Content
0
Former Member
Oct 18, 2005 at 04:53 AM

Create the Last Education Background for employee

54 Views

Hi everyone,

I have a problem when creating the query to get the last education Background for employee.

I will get the data from ODS Employee-Education (0PA_DS04) which is content with all the educational background of each employee strating from junior high school until graduate and so on.

I have a characteristic field 'ValidTo'to represent the end of its education. But how I can get ONLY the last education background or the last 'ValidTo' field ?

Please let me know what you think.

Thanks a lot for your help 😊

-Martin Darmawi-