Re: [sqlite] how to select first n records

Rael Bauer wrote: Hi, Can someone tell me how to select first n records from a query (for e.g. Interbase has syntax: "rows 1 to n") SELECT * FROM Table LIMIT 10; or SELECT * FROM Table LIMIT 15,10; Shows 10 records, starting at the 15th. -- Scott Baker - Canby Telcom RHCE - Syst

[sqlite] how to select first n records

Hi, Can someone tell me how to select first n records from a query (for e.g. Interbase has syntax: "rows 1 to n") Thanks Rael - Looking for last minute shopping deals? Find them fast with Yahoo! Search.