View previous topic :: View next topic
|
Author |
Message |
veera Warnings : 1 New User
Joined: 24 Nov 2004 Posts: 20 Location: chennai
|
|
|
|
hello,
any one plse tell me,how to select nth row from table. |
|
Back to top |
|
|
jz1b0c
Active User
Joined: 25 Jan 2004 Posts: 160 Location: Toronto, Canada
|
|
|
|
Veera,
Once a query posted please do not post it again.
SELECT *
FROM TEST.TABLE1 T1
WHERE 5 = ( SELECT COUNT(DISTINCT T2.NUM)
FROM TEST.TABLE2 T2
WHERE T2.NUM >= T1.NUM)
ORDER BY NUM DESC ;;
This should solve your problem. |
|
Back to top |
|
|
khamarutheen
Active Member
Joined: 23 Aug 2005 Posts: 677 Location: NJ
|
|
|
|
hi frnd,
u can enter the row condition which u are going to retrive na. then use that..
Eg:
Select * from emp
where emptno=:empno;
hope enough.. let me know if wrong |
|
Back to top |
|
|
|