SQL 子句“GROUP BY 1"是什么意思?意思是?
有人向我发送了一个 SQL 查询，其中 GROUP BY 子句包含以下语句:GROUP BY 1.
Someone sent me a SQL query where the GROUP BY clause consisted of the statement: GROUP BY 1.
这一定是打错字了吧?没有列被赋予别名 1.这意味着什么?我是否正确地认为这一定是一个错字?
This must be a typo right? No column is given the alias 1. What could this mean? Am I right to assume that this must be a typo?
推荐答案
意思是按第一列分组，不管它叫什么.你可以用 ORDER BY 做同样的事情.
It means to group by the first column regardless of what it's called. You can do the same with ORDER BY.
相关文章