Which clause is used to "sort the rows of the final result set by one or more columns"?
A. HAVING
B. ORDER BY
C. WHERE
D. FROM
Answer: Option B
Solution (By Examveda Team)
This question asks about the clause in SQL that helps you arrange the data in your final result set. Imagine you have a list of students with their scores, and you want to see them organized from highest to lowest score. That's where the "ORDER BY" clause comes in.Here's why the other options are incorrect:
* HAVING: This clause is used for filtering data after grouping is applied.
* WHERE: This clause is used for filtering data based on conditions before any grouping or sorting.
* FROM: This clause specifies the table from which you want to retrieve data.
Therefore, the correct answer is Option B: ORDER BY.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion