1，WHERE s1.article = s2.article
2，SELECT MAX(s2.price) FROM shop s2
3，price=(SELECT MAX(s2.price) FROM shop s2 WHERE s1.article = s2.article);
4，SELECT article, dealer, price
FROM shop s1
我觉得你肯定弄错什么了
shops1和shops2肯定是表啊
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024