I have similar requirement. If I have null dated record along with other dated records for same empl id, I need to pick only null dated record.
If there are say two records with date and no null dated records for same empl id then I need to fetch max date.
How can I achieve this?