62,017
社区成员
发帖
与我相关
我的任务
分享
select row_number() over(order by 车主名) as '编号',车主名,isnull(sum(应付金额-已付金额),0) as '应付金额'
from tableName
group by 车主名
select row_number() over(order by 车主名) as '编号',车主名,isnull(sum(应付金额-已付金额),0) as '应付金额'
from tableName