--- 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
