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