........... clause allows sorting of query results by one or more columns.

Question

Accepted Answer

The correct option is (1):
The ORDER BY clause in Structured Query Language (SQL) is the specific and primary command used to sort the data retrieved by a SELECT statement. When a query is executed, the database management system (DBMS) does not guarantee any particular order for the result rows unless an ORDER BY clause is explicitly used. This clause allows you to specify one or more columns by which the output should be arranged, either in ascending (ASC) or descending (DESC) order, making the query results presentable and logically ordered for reporting and analysis.

The incorrect option is (2):
The ALL keyword serves multiple purposes in SQL, none of which is to sort the final result set. It can be used as a set quantifier in subqueries (e.g., comparing a value to all values returned by a subquery) or as a default specifier in the SELECT clause, indicating that all rows, including duplicates, should be considered. It dictates the inclusion or comparison of data, but it has no function in arranging the sequential order of the output records. Its role is logical and inclusionary, not structural or presentational like sorting.

The incorrect option is (3):
The WHERE clause is a fundamental component of a SELECT query, but its purpose is to filter the records based on a specified condition. It performs row-level restriction, determining which rows are included in the result set before any sorting takes place. To be clear, the WHERE clause selects the rows, while the ORDER BY clause arranges them. Therefore, the WHERE clause is concerned with the content of the result, not the presentation order.

The incorrect option is (4):
The DISTINCT keyword is used to eliminate duplicate rows from the query results. When placed immediately after SELECT, it ensures that every returned row is unique. For example, selecting DISTINCT names will return each name only once, even if it appears multiple times in the table. While it modifies the content of the result set, it does not define the sequence in which the unique rows are then presented. The sorting operation is a separate and subsequent step that requires the ORDER BY clause.