Skip to Content
0
Former Member
Dec 14, 2007 at 05:50 AM

selecting the data from the table

13 Views

Hi,

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.

ex-

cus date

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.

Regards

Kumar Shantanu