To sort the results of a query use:a.GROUP BY.b.None of the above is correct.c.ORDER BY.d.SORT BY.

Answer Explanation

To sort the results of a query in SQL, the correct command to use is c. ORDER BY.

Why ORDER BY?

1. Functionality: The ORDER BY clause is specifically designed to sort the result set of a SQL query based on one or more columns. It allows for both ascending (default) and descending order sorting, which provides flexibility depending on the requirement.

2. Example:

   • If you want to retrieve a list of employees sorted by their last name, the SQL command would look like:

     SELECT * FROM employees
     ORDER BY last_name ASC;
     

   • Here, ASC indicates sorting in ascending order.

3. Comparison with Others:

   • a. GROUP BY: This clause is used to arrange identical data into groups but does not sort the result set; rather it aggregates data.
   • b. None of the above is correct: This option is incorrect since ORDER BY is a valid command for sorting.
   • d. SORT BY: This phrase is not standard SQL syntax. Instead, ORDER BY is the recognized term across SQL databases.

In summary, when you want to sort your query results in SQL, you should always use the ORDER BY clause for precise control over the sorting of your data.