Question
Computer Science Question on Query using SQL
Which of the following statement is NOT correct ?
A. By default, ORDER by clause sorts the result set in decreasing order
B. SUM() function is used to count the total no. of records in a table
C. By default, ORDER BY clause sorts the results set in increasing order
D. AVG() is an aggregrate function
E. The WHERE clause is used to specify filtering conditions for groups
Consider the correct answer from the options given below :
A
A, C and D only
B
B, C and D only
C
A, B and E only
D
A, B and C only
Answer
A, B and E only
Explanation
Solution
The correct option is (C) :A, B and E only.