Question

数据库 sql语句 聚合函数

select max(sum(btotal)),bpublish
from book
group by bpublish

提示错误：
服务器: 消息 130，级别 15，状态 1，行 1
不能对包含聚合或子查询的表达式执行聚合函数。

请帮忙改下，谢谢，在线等，急！
意思就是先求出和来，在和里面找出最大值

Answer 1

聚合不能嵌套，可以放到子查询里面。
select max(t) from
（select sum(btotal) as t
from book
group by bpublish）；

Answer 2

select top 1 sum(btotal) as thesum,bpublish from book group by bpublish order by thesum desc

Answer 3

select max(a.sum_btotal),a.bpublish from
(select sum(btotla) as sum_btotal,bpublish
from book
group by bpublish) a
group by a.bpublish

Answer 4

函数本身就有错误
求和与最大值怎么能一起用。。
不懂你要做什么