求sql 汇总语句

[xwqjamky]

table
id jzl
1 2
2 5
3 8
4 1
5 4
6 6

得到结果如下a列一共多少条数据,b列为jzl总和
a b
6 16


请问这个语句怎样写

[冷箫轻笛]

select count(*) as a,sum(jzl) as b from table

[caixia615]

select count(*) as a,b=sum(jzl) from tablename group by id

[marco08]

select a=(select count(*) from tbName),
b=(select sum(jzl) from tbName)

[marco08]

create table T(id int, jzl int)
insert T select 1, 2
union all select 2, 5
union all select 3, 8
union all select 4, 1
union all select 5, 4
union all select 6, 6

select a=count(*), b=sum(jzl) from T
--result
a b
----------- -----------
6 26

(1 row(s) affected)

[feixiangVB]

select count(*) as a,sum(jzl) as b
from tbname

[中国风]

select 记录=count(id),--就id的记录
sum(jzl) from table

[feixiangVB]

暈~~~樓頂早該出答案了

強烈建議,以後此類小問題,高手就不要搶答了,給我們這些小鳥一點思考+接分的空間嘛!

[秋水森]

select count(id) as a,sum(jzl) as b from a

[feixiangVB]

再頂哈子~~~~~~~

[xiequanqin]

都是正解。。。

[xiequanqin]

除了有Group 的。。~-~

[shirely]

都是对的~~