Re: [sqlite] how to select first n records

[Scott Baker]

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 - System Administrator - 503.266.8253

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------