Hello,
I have an order which is having multiple dates but i want to have only the latest of them all .
Like this, whenever we have same orders with multiple dates, the maximum date only has to be displayed in the query.
For example,
Order Date (DD/MM/YYYY)
900001 01.02.2009
900001 02.02.2009
900002 03.02.2009
900002 04.02.2009
Finally, in the query the below orders should only be displayed.Why because, these are the max dates.
900001 02.02.2009
900002 04.02.2009
Please let me know solution for the above requirement.
Thanks
Ravi