https://community.oracle.com/customerconnect/discussion/comment/1176715#Comment_1176715 2024-06-30 retrieves "No Results"

Important functionality

@Raghavendra Raghunath-Oracle Thanks! its retrieves the right max Email. But how can I display (marge) it into one Column ?

Hi @Raghavendra Raghunath-Oracle thank you for your answer. But my final report should display 1 column for email: If the employee have work email, Its displays work email else, it displays home email. and it should be use the max for 1 row for each emp.

https://community.oracle.com/tech/apps-infra/discussion/comment/16842447#Comment_16842447 I have more columns in my table so I must to display the latest inactive row, only once + active. which of those two option is apply the max date? the result is still not working: