Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 72 of 79

MySQL SQL Revision Tour — Question 15

Back to all questions
15
Question

Question 15

Ravisha has stored the records of all students of her class in a MYSQL table. Suggest a suitable SQL clause that she should use to display the names of students in alphabetical order.

  1. SORT BY
  2. ALIGN BY
  3. GROUP BY
  4. ORDER BY
Answer

ORDER BY

Reason — The suitable SQL clause that Ravisha should use to display the names of students in alphabetical order is ORDER BY. The ORDER BY clause in SQL is used to sort the result set of a query, and by default, it sorts the results in ascending order.