Database-Management-System

Question 659

Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ?

A	SELECT A FROM R;
B	SELECT A, COUNT(*) FROM R;
C	SELECT A, COUNT(*) FROM R GROUP BY A;
D	SELECT A, B, COUNT(*) FROM R GROUP BY A, B;

Database-Management-SystemSQLUGC NET CS 2016 Aug- paper-2

Question 659 Explanation:

The aggregate functions can’t be used without Group By clause.
Common aggregate functions include : COUNT,AVG,MAX,MIN,SUM

Correct Answer: B

Question 659 Explanation:

The aggregate functions can’t be used without Group By clause.
Common aggregate functions include : COUNT,AVG,MAX,MIN,SUM