Question
DBMS Question on SQL
Which of the following statements are true?
(A) Where condition in SQL can include aggregate functions.
(B) Having condition in SQL can include aggregate functions.
(C) SQL set operators tend to combine columns from two or more tables.
(D) GROUP BY function is used to group rows of a table that contain the same values in a specified column.
(E) Minus operator is also known as intersect operator.
Choose thecorrect answer from the options given below:
A
(A) and (C) only
B
(C) and (E) only
C
(B) and (D) only
D
(A), (C) and (E) only
Answer
(B) and (D) only
Explanation
Solution
The correct option is(C): (B) and (D) only