SQL Sorting and Limiting: ORDER BY Clause

Sort Products by Price

Write a query to select product names and prices from a products table, sorted by price in ascending order.

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

Hint: Use ORDER BY price ASC.

Top 3 Recent Orders

Write a query to retrieve the top 3 most recent orders from an orders table, sorted by order date descending.

Expected output: Three most recent orders listed first.

Hint: Use ORDER BY order_date DESC with LIMIT 3.

Sort Employees by Department and Hire Date

Write a query to list employees sorted by department ascending and hire date descending.

Expected output: Employees grouped by department with newest hires first.

Hint: Use ORDER BY department ASC, hire_date DESC.

The default sort order is ascending (ASC) if no direction is specified.

Yes, you can specify multiple columns in ORDER BY to sort data hierarchically.

ORDER BY sorts the data first, then LIMIT restricts the number of rows returned from the sorted result.