RE: [GENERAL] LIMITS in SELECTs

1999-01-09 Thread Neil Burrows
Hi, > Is there a way to select only a range of rows from a table, using > a command > like: > > SELECT * FROM table WHERE where_statement LIMIT 50,100; Assuming you use a "Order By" clause to make sure you got the records in the appropriate order there is a patch file in the "patches" directory

Re: [GENERAL] LIMITS in SELECTs

1999-01-09 Thread dustin sallings
On Sat, 9 Jan 1999, Fabrice Scemama wrote: // Is there a way to select only a range of rows from a table, using a command // like: // // SELECT * FROM table WHERE where_statement LIMIT 50,100; That doesn't make sense in a relational database by itself since it's not guaranteed to retu

[GENERAL] LIMITS in SELECTs

1999-01-09 Thread Fabrice Scemama
Hi ! Is there a way to select only a range of rows from a table, using a command like: SELECT * FROM table WHERE where_statement LIMIT 50,100; I've tried, and then read the doc, but found no information so far. Thanks in advance. Fabrice Scemama