[sqlite] Re: how to select first n records

[Igor Tandetnik]

Rael Bauer <rael_bauer-/[EMAIL PROTECTED]> wrote:
 Can someone tell me how to select first n records from a query

select * from mytable limit 10;

Or, you can simply call sqlite3_step as many times as necessary, then 
reset the statement.


See also OFFSET clause:

select * from mytable limit 10 offset 5;

Meaning, select 10 rows beginning with 5th one (the offset is 
zero-based).

Igor Tandetnik 


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