Re: LIMIT, ORDER Dilema

[Paul DuBois]

At 12:22 -0800 3/30/02, destr0 wrote:
>----- Original Message -----
>From: "Tyler Longren" <tyler@stripped>
>To: "destr0" <joellist@stripped>; <mysql@stripped>
>Sent: Saturday, March 30, 2002 9:38 AM
>Subject: Re: LIMIT, ORDER Dilema
>
>
>>  You have to have the LIMIT clause after the ORDER clause.
>
>If this is the case than can someone give me an example of a select query
>that would select records 30 - 45 of a table
>and then order those selected records by certian fields.  becuase if I have
>the "order by" clause first, that throws the result set I'm looking for out
>of order.

Does that even make sense?  "records 30 - 45" has no meaning, given
that the server is free to return records in any order it pleases.