--- In [email protected], James Keeline <[EMAIL PROTECTED]> wrote:
>
> 
> --- 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
>

LIMIT 1,3 worked. The first number skips that number of rows, the second number 
displays that number of rows.

THANK YOU!!!!!!!!!!

Reply via email to