Paul Hilton <[EMAIL PROTECTED]> wrote: > In the sqlite documentation under > http://www.sqlite.org/lang_select.html > it says: > "The limit is applied to the entire query not to the individual SELECT > statement to which it is attached." > > Why does that not apply to the 'Select *' in this query?
The phrase you quote talks about a compound query - one like this: select * from table1 union all select * from table2 limit 100; It says limit is applied to the whole union, not just to the last query in the union. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
