I have a query where in the table a single customer is having many entries and all those entries has corresponding date on which it was created
My select statement has to get the most recent date out of it.
1 - 20.07.2007
2 - 13.06.2007
3 - 15.09.2007
then it should fetch 3 - 15.09.2007
I cannot use the MAX or any of the aggregate function as i am using FOR ALL ENTRIES statement.
Any pointers will be very helpful.
Please suggest the solution keeping the performance in mind as FOR ALL ENTRIES itab is having many customer data.