PL/SQL (MOSC)

MOSC Banner

How to fetch the desired record in sql

edited Jan 13, 2013 3:22PM in PL/SQL (MOSC) 12 commentsAnswered ✓
Hello ,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center