怎么把带有小计，合计的sql语句放到结果集中，并从结果集中读出

Question

1.如果不行，是不是要用报表JasperReport

Answer 1

我的语句大概这样
select c.servicename,c.serviceid,c.unionmobileinfo,c.lastnum,c.currentnum,c.ordernum,c.unordernum,c.feenum from (select  servicename,serviceid,unionmobileinfo,sum(lastnum) as lastnum,sum(currentnum) as currentnum,sum(orderNum) as orderNum,sum(unorderNum) as unorderNum,sum(feeNum) as feeNum  from union_increase  where 1=1 and subString(convert(char,regtime,112),0,7)='200601' group by servicename,un

Answer 2

从发一份
select c.servicename,c.serviceid,c.unionmobileinfo,c.lastnum,c.currentnum,c.ordernum,c.unordernum,c.feenum from (select  servicename,serviceid,unionmobileinfo,sum(lastnum) as lastnum,sum(currentnum) as currentnum,sum(orderNum) as orderNum,sum(unorderNum) as unorderNum,sum(feeNum) as feeNum  from union_increase  where 1=1 and　subString(convert(char,regtime,112),0,7)='200601' group by servicename,unionmobileinfo,serviceid) as c group by c.servicename,c.serviceid,c.unionmobileinfo ,c.lastnum,c.currentnum,c.ordernum,c.unordernum,c.feenum order by c.servicename compute sum(c.lastnum),sum(c.currentnum),sum(c.ordernum),sum(unordernum),sum(feeNum) by c.servicename