Which one of the following is used to sort rows in SQL?

Question

Accepted Answer

The correct option is (3):
The clause specifically designed in Structured Query Language (SQL) to sort the rows in a query's result set is ORDER BY. It is the final logical operation performed in a SELECT statement, responsible for arranging the output in a desired order, such as alphabetically, chronologically, or numerically. By default, the sorting is done in ascending order (ASC), but the programmer can explicitly specify descending order (DESC) to reverse the sequence. It's crucial to remember that without the ORDER BY clause, the SQL standard makes no guarantee about the order of the rows returned, as the database engine simply returns them in the most efficient manner possible.

The incorrect option is (1):
SORTBY is not a valid or standard clause in SQL for ordering query results. While the function of sorting is what the question addresses, SQL uses a specific, reserved keyword combination for this purpose, which is ORDER BY. Using SORTBY in a standard SQL environment will result in a syntax error, as it is not recognized by the database management system (DBMS) as a command to arrange rows. It is important for students to know the precise syntax mandated by the SQL standard.

The incorrect option is (2):
ALIGNBY is also not a recognized clause in standard SQL. The term 'align' relates more to presentation aspects of data layout or column justification, concepts that are handled by client-side reporting tools or application logic, not by the core SQL language itself. Therefore, attempting to use ALIGNBY within a SELECT query will fail because it holds no meaning for the database engine. In database contexts, we focus on data manipulation and retrieval, not the visual arrangement of output text.

The incorrect option is (4):
GROUPBY is a fundamental and standard SQL clause, but its purpose is entirely different from sorting. The GROUP BY clause is used to aggregate data, which means it collapses identical rows into a single summary row, typically in conjunction with aggregate functions like COUNT, SUM, AVG, or MAX. It groups rows that share the same values in the specified column(s). Although grouping often affects the appearance of the result, its function is aggregation, not the simple arrangement (sorting) of the final set of individual rows.