Find sql summary statement

zxmsgdhr

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

The result is as follows: how many data is there in column a, and column j is the sum of jzl
a b
6 16


How to write this sentence

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 record = count (id),-record of id
sum (jzl) from table

vcblue

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

wgfxman

They are all positive solutions. . .

wgfxman

Except for Group. . ~-~