Give each line a few extra spaces. I don't know why, but I had the same error. I gave a few extra spaces, specially at the end, and it worked just find...
----- Original Message ----- From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org> Sent: Thursday, December 14, 2006 7:15 AM Subject: [sqlite] GROUP BY in SQLite
Just wondering about the implementation of GROUP BY in SQLite. It looks I can do: select field1, field2, field3 from table group by field1 and I will get the last row in the field1 group. This is fine and I can use that, but I thought that the SQL standard was that all non-aggregate fields should be in the GROUP BY clause. I just tried it in Interbase and the above construction indeed doesn't work with the error: SQL error code = -104, invalid column reference Runs fine though in SQLite. Is this a known feature? RBS ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------