In SQL, how do I get all rows where a column's value is the lowest in the table?

Question

I am a newbie to SQL, I am using this query to look for the minimum value in the field weight of my table.

SELECT product_id, 
       MIN(weight) 
  FROM table 
 WHERE 1;

It does show one field with the min value, but only one? But I have many products with the same minimum weight. Is there a way I could specify that I need to show all other products?

Answer 1

select * from table where weight = (select MIN(weight) from table)