How SQL execution orders varies across databases

How SQL Execution Orders Varies Across Databases

Why you can’t GROUP BY ordinal positions in SQL Server but can in others

After working regularly with open-source databases such as MySQL and PostgreSQL, I recently had the chance to work on a SQL Server project and discovered a subtle but important difference in the SQL landscapes. I observed that in SQL Server, I was unable to GROUP BY ordinal positions (GROUP BY 1, …

author bigquery chance databases image mysql orders ordinal postgresql project server sql sql-server work