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

Reply via email to