Re:The Next 50 Years of Databases (2015)
by sanderjd on Wednesday November 13, 2019 @01:31PM
(#21527618)
Your summary is wrong. When you write "select field" you are saying which field to return from the query. When you write "group by field", you are saying that you want the query to group by that field when generating query results. You are not writing anything twice, you are writing two different things.
[ Parent
| on HN ]
Re:The Next 50 Years of Databases (2015)
by paulddraper on Wednesday November 13, 2019 @04:16PM
(#21529663)
When I write "select field" I am saying which field I want to return from the query and which field I want to group by. There's no difference. And the DBMS enforces that there is no difference. *
* Except for the special case when it's non-aggregated and I want duplicate rows in the result set. SQL allowing duplicate rows is a departure from the underlying relational paradigm.