Steffen Mangold <steffen.mang...@balticsd.de> wrote: > SELECT name FROM employee ORDER BY name ASC LIMIT 99 OFFSET 9999 > > Of course this only works if the LINQ expression has a Take(m) clause > specified besides Skin(n). If Take(m) is not specified you > could work around by inserting a fake "LIMIT" clause, eg.: > > SELECT name FROM employee ORDER BY name ASC LIMIT (SELECT count(*) FROM > employee) OFFSET 9999
... or you could just write "LIMIT -1". Negative values mean "no limit". -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
