IIT Madras MS written test 2019 - DBMS

Question

Which of the following statements about SQL queries is true?

1. The GROUP BY clause has nothing to do with Aggregate functions.
2. The GROUP BY clause can only be used when Aggregate functions are used.
3. Aggregate functions can only be used when the GROUP BY clause has been used.
4. The GROUP BY clause can be used even when Aggregate functions are not used.

Comments

IV is True.

Either Group by is used with Aggregate Function OR Attribute in Group By must appear in SELECT Statement.

Answer 1

iv.

with group by clause , we can use an aggregate function as well as column also on which we have performed grouping  as select statement

Answer 2

normally GROUP BY clause is used with Aggregate function. However GROUP BY clause can be used without aggregate function also. hence the option IV is correct.