This is just one replacement for "distinct on" clause, as example. And you
can use any sort order for non-aggregate values in your group so some
queries are more simple than equal "distinct on" form in other DBMS
(PostgreSQL,
etc.). The feature is extremely useful for many applications.

2010/10/18 <ivoryjoh...@gmail.com>

> I made an error in my SQL when I did not include one of my non-aggregate
> columns in my group.  I was surprised that Sqlite did not catch this, and
> even more surprised when the docs spelled out this behavior.
>
> Is everyone ok with this?
> Do any other SQL engines allow this?
> (DB2 does not)
>
>
-- 
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to