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
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.