34,590
社区成员
发帖
与我相关
我的任务
分享
select CONVERT(nvarchar(10), Time1, 20) as Time2,usercode,(0-sum(money))
from [table] group by usercode,CONVERT(nvarchar(10), time1, 20) order by time2
select CONVERT(nvarchar(10), Time1, 20) as Time2,usercode,(0-sum(money)),max(id) as lastid
from [table] group by usercode,CONVERT(nvarchar(10), time1, 20) order by time2
select
CONVERT(nvarchar(10), Time1, 20) as Time2,
usercode,(0-sum(money)),
lastbalance=(select top 1 balance from [table] where usercode=t.usercode and CONVERT(nvarchar(10),time1,20)=CONVERT(nvarchar(10),time1,20) order by id desc)
from [table] t
group by usercode,CONVERT(nvarchar(10), time1, 20)
order by time2