Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Skip records
In select statment one can use "Fetch first 2000" to fetch first 2000 records in a table. Is there a way to fetch records 2001 to 4000 and so on. Is there a way to skip records. I know in MySQl one can do: LIMIT 2001,4000 to fetch records 2001 to 4000. I would appreciate any help in this...
