I wanted to know if generally people use group by with the numbers instead of the column names. Is this something old school or just bad practice? It makes it so much harder to read.
3 Likes
Use column names, in essence. Consider who else might utilize the code in the future.
3 Likes
I completely agree with you as someone who is on the other end and cannot grasp the SQL that someone else has written.
2 Likes
When I conduct unions, I use numbers, and the select has various field names but the same type.
2 Likes
my life’s narrative
1 Like
However, what is the purpose of reading the group by column names? The select contains the column names.