Class 12: SQL Question Set 3 5

21.
By default, the order by clause sorts the result set in the ________ order.

 

22.
To specify filtering condition for groups , the _____ clause is used in MySQL.

 

23.
The ________ function returns returns the total number of rows , including duplicates and NULL in a table.

 

24.
Group functions are also called as _________ functions.

 

25.
In MYSQL, ________ option causes a group function to consider only unique values.