Discussion Forum

Que. Which of the following statements are TRUE about an SQL query?
P : An SQL query can contain a HAVING clause even
if it does not have a GROUP BY clause
Q : An SQL query can contain a HAVING clause only
if it has a GROUP BY clause
R : All attributes used in the GROUP BY clause must
appear in the SELECT clause
S : Not all attributes used in the GROUP BY clause
need to appear in the SELECT clause
a. P and R
b. P and S
c. Q and R
d. Q and S
Answer:Q and R
Confused About the Answer? Ask for Details Here
Know Explanation? Add it Here

Similar Questions: