参考https://blog.csdn.net/lglaljj123/article/details/79864188
select * from (select * from shop order by price desc limit 999999) a GROUP BY a.shop_name;
参考https://blog.csdn.net/lglaljj123/article/details/79864188
select * from (select * from shop order by price desc limit 999999) a GROUP BY a.shop_name;