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-