Solve this SQL QUERY

amitjain231 · New User Joined: 04 Mar 2005 Posts: 8 Location: asd

HI CAN ANYONE HELP ME IN FORMULATING A QUERY WHERE BY ONE DISPLAY SELECTIVE ROWS FROM A SELECT QYERY..
FOR EXAMPLES GIVING A QUERY..
SELECT * FROM TABLE_NAME;
WHEREIN I WANT TO DISPLAY FROM 500TH ROW TO 525TH ROW ONLY.
WE DO HAVE FETCH FIRST N ROWS ONLY CLAUSE...
BUT WHAT FETCHING IN BETWEEN?[/b]

ovreddy · Posted: Fri Mar 25, 2005 6:17 pm

Hi,

If you have Primary key value then use it. If you dont have use ROWNUM. But I wont suggest it. You should have a Key for Table to access.

Still you need any thing mail me the real situation where its really needed.

Thanks,
Reddy.