Select query

[Dali]

If in mysql database there's a column with some values that are repeating, for example group number for certain products, is it possible to select only the first product of each group? (if prodId 001, 002 and 003 have the same group 1, select only 001)

[webtea]

select min(prodID)
from product_groups
group by groupID