Skip to content

Latest commit

 

History

History
16 lines (12 loc) · 206 Bytes

ex10.md

File metadata and controls

16 lines (12 loc) · 206 Bytes

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
)