select sum(MONEY) from TableName where ID in (select distinct ID from TableName)
刚才的只显示了money和,下面的语句显示了id和money 和。 select id,sum(MONEY) from tt where ID in (select distinct ID from tt) group by id
SELECT ID, name, SUM(MONEY) AS SUMMONEY FROM a3 GROUP BY ID,name
SELECT ID, NAME, SUM(MONEY) AS MONEY FROM 表 where ID=12
上述的除了 iknowwn(常乐)所写的理解了楼主的意思,其它人写的没有正确理解。SELECT ID, NAME, SUM(MONEY) AS MONEY FROM 表 where ID=12或者使用 declare @ID int set @ID='12'SELECT ID, NAME, SUM(MONEY) AS MONEY FROM 表 where ID=@ID
where ID in
(select distinct ID from TableName)
select id,sum(MONEY) from tt
where ID in
(select distinct ID from tt)
group by id
FROM a3
GROUP BY ID,name
FROM 表
where ID=12
FROM 表
where ID=12或者使用
declare @ID int
set @ID='12'SELECT ID, NAME, SUM(MONEY) AS MONEY
FROM 表
where ID=@ID