Display a List of Products with the Largest Weight?

Question

SQL

Hello, please help me to write a database query.
There is a table with the name of the goods, each product has a PRICE and WEIGHT,
in the table there are goods with the same Name, but with different WEIGHT, it is
required to display a list of the heaviest goods.
Such a Request - will display One item with max. weighing

"SELECT * FROM product WHERE massa=(SELECT MAX(massa) FROM product"

Here is the table:

names     |massa  | price
 ____________ |_____  |______
песок (мешки) | 30.00 | 150
песок (мешки) | 35.50 | 170
песок (мешки) | 32.00 | 161
глина (мешок) | 17.00 | 55
глина (мешок) | 17.15 | 57
цемент        | 25.00 | 100
цемент        | 30.00 | 150

Should output like this:

песок (мешки) 35.50 | 170
глина (мешок) 17.15 | 57
цемент        30.00 | 150

Answer 1

Try like this:

SELECT *, `names` as `nm` 
FROM `product` 
HAVING `massa` = (
    SELECT max(`massa`) 
    FROM `product` 
    WHERE `names` = `nm`
) 
ORDER BY `names` 
ASC