SQL Sorting and Limiting: Ascending Sorting Explained

Sort Products by Price

Write a SQL query to list all products sorted by their price in ascending order.

Expected output: A list of products starting from the lowest price to the highest.

Hint: Use ORDER BY with the price column.

Sort Employees by Department and Hire Date

Write a SQL query to sort employees first by Department ascending and then by HireDate ascending.

Expected output: Employees grouped by department with earliest hire dates first.

Hint: Use multiple columns in ORDER BY.

The default sorting order is ascending when using ORDER BY without specifying ASC or DESC.

List the columns in the ORDER BY clause separated by commas, each optionally followed by ASC, for example: ORDER BY column1 ASC, column2 ASC.

Yes, ASC is the default sorting order, so it can be omitted.