To sort rows in SQL, the correct option is **ORDER BY**.

### Explanation:
The `ORDER BY` clause is used in SQL to sort the result set of a query by one or more columns. You can specify whether the sorting should be in ascending (ASC) or descending (DESC) order. For example, the SQL statement:

```sql
SELECT * FROM employees ORDER BY last_name ASC;
```

This command will retrieve all records from the `employees` table and sort them by the `last_name` column in ascending order.

In contrast:
- **SORT BY** is not a standard SQL term.
- **ALIGN BY** is not recognized as standard SQL syntax for sorting.
- **GROUP BY** is utilized for grouping rows that have the same values in specified columns into summary rows, which is different from sorting.

Thus, the correct choice here for sorting rows is **ORDER BY**.

Question

To sort rows in SQL, the correct option is **ORDER BY**.

### Explanation:
The `ORDER BY` clause is used in SQL to sort the result set of a query by one or more columns. You can specify whether the sorting should be in ascending (ASC) or descending (DESC) order. For example, the SQL statement:

```sql
SELECT * FROM employees ORDER BY last_name ASC;
```

This command will retrieve all records from the `employees` table and sort them by the `last_name` column in ascending order.

In contrast:
- **SORT BY** is not a standard SQL term.
- **ALIGN BY** is not recognized as standard SQL syntax for sorting.
- **GROUP BY** is utilized for grouping rows that have the same values in specified columns into summary rows, which is different from sorting.

Thus, the correct choice here for sorting rows is **ORDER BY**.

Knowee AI · Accepted Answer

To sort rows in SQL, the correct option is **ORDER BY**.

### Explanation:
The `ORDER BY` clause is used in SQL to sort the result set of a query by one or more columns. You can specify whether the sorting should be in ascending (ASC) or descending (DESC) order. For example, the SQL statement:

```sql
SELECT * FROM employees ORDER BY last_name ASC;
```

This command will retrieve all records from the `employees` table and sort them by the `last_name` column in ascending order.

In contrast:
- **SORT BY** is not a standard SQL term.
- **ALIGN BY** is not recognized as standard SQL syntax for sorting.
- **GROUP BY** is utilized for grouping rows that have the same values in specified columns into summary rows, which is different from sorting.

Thus, the correct choice here for sorting rows is **ORDER BY**.

Which one of the following sorts rows in SQL?1.0 MarksSORT BYALIGN BYORDER BYGROUP BYClear Answer

Question

Which one of the following sorts rows in SQL?

Solution

Explanation:

Similar Questions

Upgrade your grade with Knowee