Computer Science
The …………… clause allows sorting of query results by one or more columns.
- ALL
- DISTINCT
- GROUP BY
- ORDER BY
SQL Queries
1 Like
Answer
ORDER BY
Reason — The SQL ORDER BY
clause is used to sort the result-set in ascending or descending order by one or more columns in a table.
Answered By
1 Like
Related Questions
…………… command helps to see the structure of a table/relation.
- Show
- Select
- Describe
- Order by
…………… is known as range operator in MySQL.
- IN
- DISTINCT
- IS
- BETWEEN
Which clause is used in query to place the condition on groups in MySQL?
- WHERE
- HAVING
- GROUP BY
- Both (i) & (ii)
Which of the following is a DDL command?
- SELECT
- ALTER
- INSERT
- UPDATE