How to fetch the desired record in sql
I have a table named st_comments and it returned follwoing rows as :
OBJECT_ID VERS_NUM COMMENTS RESULT_VERSION
1 11007 0 <CLOB> 1
2 11007 1 <CLOB> 1
3 11007 2 <CLOB> 1
4 11007 0 <CLOB> 2
5 11007 1 <CLOB> 2
I need a query which would fetch me only the 5th record which is the latest in the list above.
Any idea?
Please help, it's urgent.
Regards,
saurav