22,209
社区成员
发帖
与我相关
我的任务
分享
select a.UserName,b.Amount from
(select distinct UserName from tbl_Finance) as a
left join
(select sum(Amount) as Amount,UserName from tbl_Finance where Amount<0 Group By UserName) b
on a.UserName =b.UserName
order by a.UserName
select sum(Amount),UserName
from tbl_Finance
Group By UserName
HAVING SUM(Amount) < 0
select sum(Amount),UserName from tbl_Finance where Amount<0 Group By UserName