View Single Post

   
  #4 (permalink)  
Old 02-28-2008, 11:29 AM
Paul Lautman
 
Posts: n/a
Default Re: Understanding LIMIT?

hadronquark@gmail.com wrote:
> Chris <matchett123@googlemail.com> writes:
>
>> Can someone explain why the query below doesn't do as I hoped it
>> would do...return the ten records proceeding the row with an id of
>> 200744? Please note that id is not an auto increment and can jump
>> from 200744 to 200801.
>>
>> SELECT * FROM weeknumber WHERE id > 200744 ORDER BY id LIMIT 0,10
>>
>> Many thanks,
>>
>> Chris

>

| proceeding means to go before.
Err, no it doesn't! Proceeding means "A course of action;" and "proceedings"
are things like legal actions.

"Preceding" (notice no "o" and no double "ee"), means
Existing or coming before another or others in time, place, rank, or
sequence; previous.


Reply With Quote