select f_name,t.maxPrice from fruits,(

select s_id,max(f_price) as maxPrice from fruits group by s_id) t?

where fruits.s_id=t.s_id and fruits.f_price=t.maxPrice

运行结果；