dimanche 21 décembre 2014

Why do we use Group by 1 and Group by 1,2,3 in SQL query?


In SQL queries, we do use Group by clause to apply aggregate functions.



  • But what is the purpose behind using numeric value instead of column name with Group by clause? For example: Group by 1.





Aucun commentaire:

Enregistrer un commentaire