RE: Finding out last 10 records

[Amjad Saiyed]

Hi Santosh,

 

i assume that u will b ordering the query based on some criteria ....

so say u have table A with column x....

 

for finding the 1st 10 records we will use the following query:

 

select x from A

where rownum < 11
order by 1

/

 

for finding the last 10 records we will use the following query:

 

select x from A

where rownum < 11
order by 1 desc

/

 

the only difference is in the ordering...

i hope this helps u out..

 

rgds,

Ams..

www.medicomsoft.com

 

 

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Santosh Varma
Sent: Wednesday, August 14, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Subject: Finding out last 10 records

Hello all

    Could any one of you guide me on how to select last 10 records from a table. and also finding out first 10 records..

Thanks and regards,

Santosh