34,587
社区成员
发帖
与我相关
我的任务
分享
/*teachername student addtime money*/
;with ach as
(
select *,rid=row_number() over (partition by teachername order by id),
(select sum(money) from tb where teachername = t.teachername) amount
from tb t
)
select (case when rid=1 then teachername else '' end) teachername,student,addtime,money,amount
from ach