SQL Questions and Answers – SQL Group By

This set of SQL Multiple Choice Questions & Answers (MCQs) focuses on “SQL Group By”.

1. Which clause is used to group the result set based on a common value present in a table?
a) Common
b) Sort
c) Group
d) Group by
View Answer

2. GROUP BY clause is used with which of the following statements?
a) Update
b) Insert
c) Select
d) Delete
View Answer

3. GROUP BY statement cannot be used with aggregate functions.
a) True
b) False
View Answer

4. How many columns or functions can be specified or included in a single GROUP BY clause?
a) Only one
b) Less than five by default
c) Two to ten
d) One or more
View Answer

5. All non aggregate function columns in the SELECT statement must be included in which of the following clause(s)?
a) Group by
b) Where
c) Order by
d) Having
View Answer

6. Which of the following provides a correct order of clauses used in SQL?
a) Where, Order By, Group By, Having
b) Group By, Order By, Having
c) Group By, Where
d) Where, Group By, Order By
View Answer

7. Which of the following is a correct syntax of GROUP BY clause?
a)

SELECT c1, COUNT(c2)
FROM TABLE_NAME
GROUP BY c2;

b)

SELECT c1, COUNT(c2)
FROM TABLE_NAME
GROUP BY c1
WHERE condition;

c)

SELECT c1, COUNT(c2)
FROM TABLE_NAME
GROUP BY c2, c1;

d)

SELECT c1, COUNT(c2)
FROM TABLE_NAME
GROUP BY c2
ORDER BY c1;

8. In the GROUP BY Clause the grouping is done using the values present in the _________
a) Entire table
b) Result set
c) Database
d) Order by clause
View Answer

9. WHERE clause is used to restrict the groups grouped using GROUP BY.
a) True
b) False
View Answer

Sanfoundry Global Education & Learning Series – SQL.

To practice all areas of SQL, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]