Hacker Newsnew | past | comments | ask | show | jobs | submitlogin
Do you use GROUP BY correctly? (dbasquare.com)
7 points by donteatbark on May 15, 2012 | hide | past | favorite | 1 comment


I often include such columns during ad-hoc analytics, because it is one valid example of the data being grouped. In particular, when COUNT(*) is 1 the value in that column is THE value, and thanks to including it in the query, I already have it. It's very convenient with very low cost.

For queries that are part of a formal process or application it's harder to find a use case.




Consider applying for YC's Summer 2026 batch! Applications are open till May 4

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: