Latest Gate Aptitude Question SOLUTION: 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 contai

• Placement Papers
• /
• Gate
• /
• Programming
• /
• Database

Gate Question Papers:

(#M40029646) GATE Programming question GATE-CS Keep an EYE

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

option
(A) P and R
(B) P and S
(C) Q and R
(D) Q and S

Asked In Gate Rats (10 years ago)

Unsolved Read Solution (1)

Is this Puzzle helpful?   (7)   (4) Submit Your Solution Database