In php group by then min group row show fist,

please help,

i need to by group which fine but start show by MIN(price) in all group,

example
id name price
5 johan 55
1 smith 70
2 wil 85
plase help

$sql = " 
SELECT name,surname,date,sold,MIN(price) as prices FROM clienttable WHERE ref= 'may' GROUP BY name ";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.