Remember, the order of rows returned from a SELECT, even one with a LIMIT clause, is undefined, so the "first 2 rows" may not be consistently the same. If you are dependent upon the rows being returned in a particular order (say by "rowid"), you should include an ORDER BY clause on your SELECT to ensure the rows are returned in the order you require.
-Shane On Wed, Apr 1, 2009 at 3:02 PM, Eric Minbiole <eminbi...@mavroimaging.com>wrote: > > Hi all, > > I have a big table and I want only select the first 2 rows. > > I have tried this : > > select top 2 from table; > > but it doesn't work! Any help please. > > JP > > Use a LIMIT clause instead of TOP: > > SELECT * FROM table LIMIT 2; > > http://www.sqlite.org/lang_select.html > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users