How to select data where a field has a min value in MySQL?

mysql sql aggregate-functions greatest-n-per-group

Sami El Hilali · Nov 13, 2012 · Viewed 124.5k times · Source

I want to select data from a table in MySQL where a specific field has the minimum value, I've tried this:

SELECT * FROM pieces WHERE MIN(price)

Please any help?

Answer

this will give you result that has the minimum price on all records.

SELECT *
FROM pieces
WHERE price =  ( SELECT MIN(price) FROM pieces )