List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 30 2002 7:53pm
Subject:RE: LIMIT, ORDER Dilema
View as plain text  
At 20:48 +0100 3/30/02, Roger Baklund wrote:
>* Paul DuBois
>>  At 13:06 -0800 3/30/02, destr0 wrote:
>>  >a select query issued on a table with an autoincremented field
>>  and no ORDER
>>  >clause seems to default to having it's results returned in order of  the
>>  >autoincremented field, ASC. I was saying "records 30 - 45" in terms of
>>  >that.
>>
>>  What you're seeing is purely coincidence and should NOT be relied on.
>>  But in this case, why don't you simply do:
>>
>>  SELECT .... ORDER BY id, col1, col2, ... LIMIT 29, 16
>
>That would return the records in the order of the id field... try this:
>
>SELECT ...
>   WHERE ... AND
>     id BETWEEN 30 AND 45
>   ORDER BY col1, col2

Yeah, you're right.  Duh.

Thanks for pointing that out.

>
>--
>Roger
>query

Thread
LIMIT, ORDER Dilemadestr030 Mar
  • Re: LIMIT, ORDER DilemaTyler Longren30 Mar
  • Re: LIMIT, ORDER DilemaPaul DuBois30 Mar
Re: LIMIT, ORDER Dilemadestr030 Mar
  • Re: LIMIT, ORDER DilemaPaul DuBois30 Mar
Re: LIMIT, ORDER Dilemadestr030 Mar
  • Re: LIMIT, ORDER DilemaPaul DuBois30 Mar
    • RE: LIMIT, ORDER DilemaRoger Baklund30 Mar
      • RE: LIMIT, ORDER DilemaPaul DuBois30 Mar
  • Calculate current age with given birthdaySon Nguyen30 Mar
    • RE: Calculate current age with given birthdayRoger Baklund30 Mar
      • RE: Calculate current age with given birthdayPaul DuBois30 Mar
        • RE: Calculate current age with given birthdayMichael Stassen30 Mar
Re: LIMIT, ORDER DilemaSteven Roussey30 Mar
RE: Calculate current age with given birthdayPaul DuBois31 Mar
  • RE: Calculate current age with given birthdayMichael Stassen2 Apr