MySQL查询fruits表中不同s_id下价格最高的水果名称以及这些水果的价格？

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

运行结果；

1、MySQL Community Edition社区版免费

2、MySQL Enterprise Edition includes the most comprehensive set of advanced features, management tools and technical support to achieve the highest levels of MySQL scalability, security, reliability, and uptime.

3、MySQL Standard Edition enables you to deliver high-performance and scalable Online Transaction Processing (OLTP) applications.  It provides the ease of use that has made MySQL famous along with industrial strength performance and reliability.