--- whoisquilty <[EMAIL PROTECTED]> wrote:

> I've got a MySQL query that sorts by a column and limits the results to only
> display the first 
> result.
> 
> I'd like another query where it sorts by the same column and displays the
> next three rows in 
> the table. So, it would need to omit the first row and show rows 2 - 4.
> 
> How do I do this?

Try to use this LIMIT clause in your query:

LIMIT 2, 3

or 

LIMIT 1, 3

I can't recall off the top of my head which one works best.  I recall
describing it to my students as how many rows to skip followed by how many to
show.  This suggests the second version is right.

James

Reply via email to