+ 1

What is the difference or respective outputs for this query ?

Select certification, Count(*) From films Group By certification and Select Count(*),certification From films Group by certification

28th May 2018, 1:24 PM
Stanley Di
Stanley Di - avatar
2 ответов
+ 3
The output should have identical data. However, the order of the columns will be reversed from each other. 1: cerification (no name) 2: (no name). certification
29th May 2018, 7:42 AM
SQrL
SQrL - avatar
0
in order words it counts the certification in both but only the order of columns changes. thank you SQrL
29th May 2018, 5:55 PM
Stanley Di
Stanley Di - avatar