- 博客(4)
- 收藏
- 关注
原创 SELECT * FROM shop s1 WHERE price = (SELECT MAX(price) FROM shop s2 WHERE s1.article=s2.article);
mysql> SELECT * FROM shop s1 WHERE price = (SELECT MAX(price) FROM shop s2 WHERE s1.article=s2.article); +---------+--------+-------+ | article | dealer | price | +---------+--------+-------+ |
2014-06-26 16:57:52 1599
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人