On Sun, Apr 20, 2008 at 5:07 PM, James Dodd <[EMAIL PROTECTED]> wrote: > Hi, > > (Newbie to sqlite, some experience with SQL Server 2000). I tried to do a > "SELECT TOP 10 * FROM tab1" and sqlite3 complained. Then I looked at the SQL > syntax page and indeed TOP doesn't seem to be there. Is there a reason for > this and, better still, is there a way to get around it? Or is it there and > I've missed it?
Perhaps this? SELECT * FROM tab1 LIMIT 10; You might also want to throw in an ORDER BY clause. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
