>> Why Sqlite doesn't support just the use of offset in select >> statements? As such SQL does support the use of offset only, without >> limit. But in case of Sqlite it's not possible to use offset without >> limit.
>select * from tableName limit -1 offset 5; >-- or >select * from tableName limit 5, -1 Can we have the following statement? Select * from tableName offset 3 I believe the above query is supported by SQL; but it's not supported by Sqlite. >> Also what is mentioned on website is different from what is there in >> parser.c file. On website Limit and offset is followed by integer >> whereas in parser.c it's followed by an expression. > An expression is allowed. I use a query that has a subselect in the > LIMIT clause (I need to return, say, top 10% of all the records). Can we have subselect in Limit Clause? On the website it says: "The limit is applied to the entire query not to the individual SELECT statement to which it is attached." What does the above statement mean? How will it work for the below given query? Select * from mainTable where xxx in (select yyy from table1) limit 10 Will the limit work for the subselect query also? Regards, Phani ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
