Informatics Practices
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.
- SORT BY
- ALIGN BY
- GROUP BY
- ORDER BY
SQL Queries
1 Like
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.
Answered By
1 Like
Related Questions
In SQL, which command is used to SELECT only one copy of each set of duplicable rows ?
- SELECT DISTINCT
- SELECT UNIQUE
- SELECT DIFFERENT
- All of the above
Which of the following types of table constraints will prevent the entry of duplicate rows?
- Unique
- Distinct
- Primary Key
- NULL
Fill in the blanks:
The _________ command can be used to select an existing database in SQL.
Fill in the blanks:
The SQL keyword _________ is used to specify the table(s) that contains the data to be retrieved.