| reg query [message #369716] |
Thu, 24 August 2000 17:33  |
Muthu
Messages: 58
Registered: August 2000
|
Member |
|
|
hello sir,
i need a query to get a N th record in the table;
(i-e) i need a query to retrieve 20 th record in the table called ANS.
please,can you send me immediately.
-muthu
|
|
|
|
|
|
| Re: reg query [message #369732 is a reply to message #369716] |
Fri, 01 September 2000 11:16  |
John R
Messages: 156
Registered: March 2000
|
Senior Member |
|
|
Or,to get the 10th row, try this:
Select field_1,field_2,...,field_n
from (select rownum num,field_1,....field_n
from table
where rownum <=10)
where num = 10
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
