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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Return ordinal groups of rows? 1
- Thread starter msgregory
- Start date
Cagliostro
Programmer
try
select top 10... John Fill
ivfmd@mail.md
select top 10... John Fill
ivfmd@mail.md
- Thread starter
- #3
-
1
- #4
SELECT * FROM tablename LIMIT 10;
SELECT * FROM tablename LIMIT 10,10;
SELECT * FROM tablename LIMIT 20,10;
SELECT * FROM tablename LIMIT 30,10;
etc...
When you have two arguments to LIMIT, the first number is the row offset, and the second one is the number of rows to show.
SELECT * FROM tablename LIMIT 10,10;
SELECT * FROM tablename LIMIT 20,10;
SELECT * FROM tablename LIMIT 30,10;
etc...
When you have two arguments to LIMIT, the first number is the row offset, and the second one is the number of rows to show.
- Status
Similar threads
- Locked
- Question