Which one of the following construct is used for sorting the data in the result set of SQL queries?

To sort data in the result set of SQL queries, the construct used is the ORDER BY clause. This clause allows you to specify one or more columns by which to sort the returned rows. You can sort the data in either ascending order (default) or descending order by using the keywords ASC for ascending and DESC for descending.

Detailed Explanation:

1. Syntax: The basic syntax for the ORDER BY clause is as follows:

   SELECT column1, column2, ...
   FROM table_name
   ORDER BY column1 [ASC|DESC], column2 [ASC|DESC], ...;
   

2. Column Selection: You can order by one or more columns, and you can specify the sort direction for each column independently.

3. Usage: This clause is commonly used when you need to present data in a specific order, such as alphabetically, numerically, or by date.

Example:

If you have a table named Employees and you want to sort the employees by their last names in ascending order, you would write:

SELECT * FROM Employees
ORDER BY LastName ASC;

In summary, the ORDER BY clause is essential in SQL for sorting data in the desired order in your query results.