select * from (select UserName, BookName,DownloadTimes, DownInte from 表 union select '' as UserName,'合计' as BookName, count(DownloadTimes) as DownloadTimes,sum(DownInte) as DownInte) T order by case when BookName='合计' then 1 else 0 end
select UserName BookName DownloadTimes DownInte from table order by userName compute sum(DownloadTimes),sum(DownInte)
select * from (select * from table union select '合计:'as BookName,sum (DownloadTimes),sum(DownInte) from table)
select UserName,BookName,DownloadTimes,DownInte from tablename order by downloadtimes compute sum(downloadtimes)
(select UserName, BookName,DownloadTimes, DownInte from 表
union
select '' as UserName,'合计' as BookName, count(DownloadTimes) as DownloadTimes,sum(DownInte) as DownInte) T
order by case when BookName='合计' then 1 else 0 end
order by userName compute sum(DownloadTimes),sum(DownInte)
order by downloadtimes
compute sum(downloadtimes)