GATE CSE - GATE 2017-2018 Questions and Answers

Home / GATE 2017-2018 / GATE CSE :: Discussion

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

P and R

P and S

Q and R

Q and S

Answer : Option C

Explanation :

-NA-

Be The First To Comment

Comments

Name