Re: Help: How to select a subset at a time?

[Davor Cengija]

On Wed, 6 Oct 1999, Ed Carp wrote:

>On Wed, 6 Oct 1999, Davor Cengija wrote:
>
>> On Wed, 6 Oct 1999, Yingyao Zhou wrote:
>> 
>> >  select * from name order by name;
>> 
>> 	select * from name order by name limit 100;
>
>I don't think that's what he meant.  If I have 1000 records, how do I
>select records 500-600?
>
	limit 500, 100 means 'start at 500 and get next 100 records,
	so, till 599 including)
-- 
      v
Davor Cengija
davor@stripped
===================================
"Please allow 30 days for delivery"