ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

Which clause is used to "sort the rows of the final result set by one or more columns"?

Answer & Solution
Correct Answer: Option B
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.