posted 20 years ago
Corey,
If you are using oracle then there are few pretty methods for getting latest record like RANK(), DENSE_RANK() or ROW_NUMBER() which will solve your problem.
even if you make WHERE RN = 2 you will get second latest record
now the best benefit which you can achieve is
If you want to get lastest SERVICE_DATE for all col1 in table.
like
then only you can modify your query as
thanks
[ January 21, 2005: Message edited by: Shailesh Chandra ]
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein