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] -----------------------------------------------------------------------------