MAX

1
SELECT MAX(price) as highest_price
2
FROM products
3
WHERE category = 'Electronics';

1
SELECT MAX(transaction_date) as last_transaction
2
FROM transactions
3
WHERE customer_id = 'CUST-001';

1
SELECT
2
  product_id,
3
  MAX(CASE WHEN region = 'ASIA' THEN sales_amount END) as asia_max,
4
  MAX(CASE WHEN region = 'EUROPE' THEN sales_amount END) as europe_max,
5
  MAX(CASE WHEN region = 'AMERICAS' THEN sales_amount END) as americas_max
6
FROM sales
7
GROUP BY product_id;

1
SELECT
2
  employee_id,
3
  department,
4
  salary,
5
  MAX(salary) OVER (PARTITION BY department) as dept_max_salary,
6
  salary / MAX(salary) OVER (PARTITION BY department) * 100 as pct_of_max
7
FROM employees
8
ORDER BY department, salary DESC;