2 ms·
HAVING applies to groups. Sqlite3 doesn't allow HAVING without GROUP BY. If a sql dialect doesn't require the GROUP BY then I think the entire select result i
by emmelaich 7y ago
HAVING applies to groups. Sqlite3 doesn't allow HAVING without GROUP BY.
If a sql dialect doesn't require the GROUP BY then I think the entire select result is one group. So you'd only get either 1 or 0 rows ever.
Or so I think :-)