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?

6 Answers
6

Leave a Reply

Your email address will not be published. Required fields are marked *