3 ms·
I universally use column positions in the GROUP BY. SELECT name, count(*) FROM account GROUP BY 1 That is still annoying, but requires less typing+modif
by paulddraper 2y ago
I universally use column positions in the GROUP BY.
SELECT name, count(*)
FROM account
GROUP BY 1
That is still annoying, but requires less typing+modification.
- code_runner 2y agoi go back and forth on this a lot, but with fewer and fewer "in production" SQL queries in my life, number based group by is definitely my default