已知表A2结构及记录:
create table A2(
bh varchar(10) null,
mc varchar(20) null,
je numeric(18,2) null
)
记录:
bh mc je
------ ---------------- -----
01 A 100.00
01 A 150.00
02 B 50.00
01 A 50.00
02 B 150.00
写一SQL语句,得出以下结果:
bh mc je
------ ---------------- -----
01 A 300.00
02 B 200.00
create table A2(
bh varchar(10) null,
mc varchar(20) null,
je numeric(18,2) null
)
记录:
bh mc je
------ ---------------- -----
01 A 100.00
01 A 150.00
02 B 50.00
01 A 50.00
02 B 150.00
写一SQL语句,得出以下结果:
bh mc je
------ ---------------- -----
01 A 300.00
02 B 200.00
from A2
group by bh,mc
01 A 100
01 A 150
01 A 50
02 B 50
02 B 150SQL> select bh,mc,sum(je)
2 from a2
3 group by bh,mc;
01 A 300
02 B 200
------ ---------------- -----
01 A 100.00
01 A 150.00
02 B 50.00
01 A 50.00
02 B 150.00
写一SQL语句,得出以下结果:
bh mc je
------ ---------------- -----
01 A 300.00
02 B 200.00 select bb,mc ,sum(je) from a2 group bh,mc;