Exercise: 10

Find the printer models having the highest price.

Result set: model, price.

Solution

SELECT model, price
FROM printer
WHERE price = (
	SELECT MAX(price)
	FROM printer
)