记录:
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
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 table
group by bh,mc
from ta
group by bh,mc