1.如果数量最大有重复的
select pno from spj where qty=(select max(qty) from spj)
2.没有重复的
select top 1 pno from spj order by qty desc
select pno
from spj
group by pno
having sum(qty)>=all(select sum(qty)
from spj
group by pno)
内容全部来源于网络收集，如有侵权，请联系网站删除!
QQ：24596024