SQL统计语句

来源：百度知道 编辑：UC知道 时间：2024/06/05 13:02:11
类似下列这张表A，要统计ND<=2001的，每个人总JE
结果为 01 张三 37.05
02 李四 22.00
这样的语句要怎么写?
XH XM ND JE
01 张三 1999 10.05
01 张三 2000 11.50
01 张三 2001 15.50
01 张三 2002 35.00
02 李四 2001 22.00
02 李四 2002 32.00

select XH,XM,sum(JE) as JE from 表A where ND<=2001 group by XH,XM

select xh as '序号',xm as '姓名',sum(je) AS '总金额'
from A
where ND<=2001
group by xh,xm

select xh,xm,je from A where nd<=2001

select xh,xm,sum(je) as je from 表A group by xm where nd<=2001

SELECT XH,XM,SUM(JE) JE FROM A
WHERE ND<2002

SELECT XH, XM, SUM(JE) FROM A WHERE ND <= 2001 GROUP BY XH, XM