Question

SQL plus max(sum(qty))语句

找出零件供应总数量最多的供应商号

select sno,max(sum(qty))
from spj
group by sno

这样的话显示有错

select max(sum(qty))
from spj
group by sno

这样只能输出最大值而不是供应商号。。怎么办？

Answer 1

不知道你什么意思，如果这么做不好用的话
可以用下面的方式试一试
select max(A) from
(
select sum(qty) as A
from spj
group by sno
)

Answer 2

select top 1 sno from
(select sno, sum(qty) as total_qty from spj group by sno) as a
order by total_qty desc

Answer 3

用子表实现 不行嘛 编程干嘛给自己找麻烦