要排序的字段加max 或 min
SELECT s
.name
,max(d
.price
),s.age FROM shop
s
INNER JOIN shop_diff
d
ON d
.shop_id
=s
.id
WHERE s
.id
> 0 GROUP BY d
.shop_id
mysql 分组后按某个字段排序
最新推荐文章于 2024-07-11 17:28:33 发布
要排序的字段加max 或 min
SELECT s
.name
,max(d
.price
),s.age FROM shop
s
INNER JOIN shop_diff
d
ON d
.shop_id
=s
.id
WHERE s
.id
> 0 GROUP BY d
.shop_id