求sql 汇总语句

zxmsgdhr

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

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


请问这个语句怎样写

michealhenry

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

我是杀人狂

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

fanfan1980

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

fanfan1980

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)

imapiggy

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

恶魔右指

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

vcblue

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

wgfxman

都是正解。。。

wgfxman

除了有Group 的。。~-~