3 ms·
"group by 1,2" is for lazy people who never have to support an application in production. It tells the database to group by the columns in the order that they
by coredog64 11y ago
"group by 1,2" is for lazy people who never have to support an application in production. It tells the database to group by the columns in the order that they come back in the result and is supported by most engines.
- nimish 11y agoit'd be bad style to use it for saved queries but for experimentation it's great
- ak4g 11y agoMuch like SELECT * or JOIN foo USING(bar), it's the kind of thing that greatly speeds up interactive queries, but shouldn't ever end up in source control.
- JoeCamel 11y agoWhy "JOIN foo USING (bar)" shouldn't be used?
- ak4g 11y agoBecause with USING, you're precluded from using the full table.column identifier in your JOIN condition. Without that, a future ALTER TABLE that adds another "bar" column to an existing table in the FROM-list will cause a previously-working query to break. https://gist.github.com/AdamG/1128b86fdafca1e53a4bd5253a6882a2 https://gist.github.com/AdamG/1128b86fdafca1e53a4bd5253a6882...