I can see now that doing SELECT name FROM SQLITE_MASTER WHERE TYPE = 'table' ORDER BY 1 ASC limit -1 offset 2
works, but it doesn't do what I was trying and that is to keep the field name out. RBS -----Original Message----- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: 06 March 2007 19:40 To: sqlite-users@sqlite.org Subject: [sqlite] What is wrong with this simple query (offset)? Why does this query give a syntax error near offset? SELECT Name FROM SQLITE_MASTER WHERE TYPE = 'table' ORDER BY 1 ASC offset 2 limit works fine. RBS ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------