Return ordinal groups of rows? 1

[msgregory]

Is there a way to get the first 10 rows, the second 10, etc. of a query, like search engine results?

 

[Cagliostro]

try
select top 10... John Fill

ivfmd@mail.md

 

[msgregory]

How do I get the second 10, I should say?

 

[rycamor]

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.