What is the difference or respective outputs for this query ? | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 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 Answers
+ 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