Excellent reply...LIMIT 1,3
 
--- In [email protected], "whoisquilty" <[EMAIL PROTECTED]> 
wrote:
>
> --- In [email protected], James Keeline <keeline@> wrote:
> >
> > 
> > --- whoisquilty <whoisquilty@> 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