Re: [sqlite] Select TOP n

Hi James, > I tried to do a > "SELECT TOP 10 * FROM tab1" and sqlite3 complained. Is this what you're after?: select * from tab1 limit 10; Tom BareFeet http://www.tandb.com.au/sqlite/compare/?ml ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Select TOP n

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 ther

[sqlite] Select TOP n

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 t