Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

First 2 Higher Number and Last 2 Lower Number

NasirApr 10 2009 — edited Apr 10 2009
Hi Experts
I have a table with the name T there are some numeric values i want to select First 2(60, 50) Higher numbers and Last 2 (10 and 20) Lower numbers with query.

I'm using Oracle 10g R2

C1
--------------
10
20
30
40
50
60

Please help me in this regard
Regards,
Nasir.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2009
Added on Apr 10 2009
9 comments
2,113 views