Interview patterns: Nth highest, top per group, duplicates: interactive SQL lesson

Interview patterns: Nth highest, top per group, duplicates · exercise 1 of 1 · free preview

Nth highest is the classic interview question. Two common answers: ORDER BY ... DESC with LIMIT 1 OFFSET n-1, or a subquery with MAX. Use whichever you can explain.

Find the second most expensive product. Show its name and unit_price.

Tables in this practice shop

customers
customer_id, first_name, last_name, city, joined_on, loyalty_tier
products
product_id, name, category, unit_price
orders
order_id, customer_id, order_date, channel
order_items
order_item_id, order_id, product_id, quantity

Loading lesson…

Interview patterns: Nth highest, top per group, duplicates · exercise 1 of 1 · free preview

Nth highest is the classic interview question. Two common answers: ORDER BY ... DESC with LIMIT 1 OFFSET n-1, or a subquery with MAX. Use whichever you can explain.

Find the second most expensive product. Show its name and unit_price.

Tables in this practice shop

customers
customer_id, first_name, last_name, city, joined_on, loyalty_tier
products
product_id, name, category, unit_price
orders
order_id, customer_id, order_date, channel
order_items
order_item_id, order_id, product_id, quantity