Someone sent me a SQL query where the GROUP BY
clause consisted of the statement: GROUP BY 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?
See Question&Answers more detail:os