View previous topic :: View next topic
|
Author |
Message |
prasadvn_mca
New User
Joined: 15 Sep 2006 Posts: 5
|
|
|
|
hai freinds,
this is prasad, can u plz help in this,
how to write a SQL Query for selecting only last 2 records in any table |
|
Back to top |
|
|
priyesh.agrawal
Senior Member
Joined: 28 Mar 2005 Posts: 1448 Location: Chicago, IL
|
|
Back to top |
|
|
chandu_usa99 Warnings : 2 New User
Joined: 21 Sep 2006 Posts: 3
|
|
|
|
Hey,
If it is clustered it is very easy.
Say your querry like this
SELECT *
FROM OEDCOD.TED_MQ_SERIES_CNT B
ORDER BY MQCNT_CLIENT_NBR DESC
,MQCNT_ADD_DATE DESC
,MQCNT_MSG_MAX_SIZE DESC
,MQCNT_MQ_MSG_TYP DESC
FETCH FIRST 2 ROWS ONLY |
|
Back to top |
|
|
anoopkhetan
New User
Joined: 22 Sep 2006 Posts: 3 Location: mumbai
|
|
|
|
Hi
see Query
Select * from 'tablename'
order by primary key DESC
fetch first 2 rows only
Anoop |
|
Back to top |
|
|
|