34,588
社区成员
发帖
与我相关
我的任务
分享
select id,name,sum(je) as je
from table_T
group by id,name
--如果JE字段没有NULL可以不需要ISNULL()函数了。
SELECT [ID],[Name],SUM(ISNULL([JE],0)) AS [JE]
FROM table_T
GROUP BY [ID],[Name]
SELECT [ID],[Name],SUM(ISNULL([JE(钱)],0)) AS [JE(钱)]
FROM table_T
GROUP BY [ID],]Name]
SELECT [ID],[Name],SUM(ISNULL([Month],0)) AS [JE(钱)]
FROM table_T
GROUP BY [ID],]Name]