Vidyalelo
MySQL · Q16

MySQL

Programming · MySQL · question 16

Q16

Find odd one out?

A.
GROUP BY
Answer
B.
DESC
C.
ASC
D.
ORDER BY

Answer: Option A

Solution

Answer: Option A
Solution:
Among the given options, GROUP BY is the odd one out.
Explanation:
DESC and ASC are used to specify the ordering of the query results (descending and ascending order, respectively) with ORDER BY.
ORDER BY is used to sort the query results based on specified criteria.
GROUP BY, on the other hand, is used to group rows that have the same values into summary rows, often used with aggregate functions such as SUM, COUNT, AVG, etc.
Option A, GROUP BY, does not relate to sorting or ordering rows like the other options, making it the odd one out.