Which of the following statements are TRUE about an SQL query? P : An SQL…
GATE · 2012 · CS · Computer Science & IT
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
Attempted by 849 students.
Sign up free to check your answer
Sign up freeLoading lesson…