Martin Gruber Understanding Sql.pdf Site

The ORDER BY clause is used to sort data in ascending or descending order. For example: $ \(SELECT * FROM customers ORDER BY last_name ASC;\) $

The WHERE clause is used to filter data based on conditions. For example: $ \(SELECT * FROM customers WHERE country='USA';\) $ Martin Gruber Understanding Sql.pdf

This query retrieves all columns (*) from the customers table where the country is ‘USA’. The ORDER BY clause is used to sort