Hi Christoph,
the id column does not appear in an aggregate function and also not in
group by.
Your statement uses 'GROUP BY Name' and so returns exactly one row per
name. If there are several rows with the same name, the ID of your
result is from one of these rows. The appropriate documenta
Hello,
I'm using sqlite over the python sqlite3 module shipped with the standard
distribution. Being not an SQL expert at all, I stumbled over an inconsistency
with a SELECT GROUP BY statement. The following python script might be
used to reproduce:
<<<
import sqlite3
print("sqlite_vers
2 matches
Mail list logo