--一个列??
合计:
select sum(T.qty) from
(
select qty from sbilldet where sbilldet.qty>0 order by sbilldet.qty
) T
合计:
select sum(T.qty) from
(
select qty from sbilldet where sbilldet.qty>0 order by sbilldet.qty
) T
union all
select sum(qty) as heji from sbilldet where sbilldet.qty>0 order by sbilldet.qty
from (
select qty from sbilldet where qty>0
union
select sum(qty) from sbilldet where qty>0
)t
order by qty
union all
(select '合计:' as 首列名,'' as 列2名,...,sum(qty) from sbilldet where sbilldet.qty>0 )
union all
select sum(qty) as heji from sbilldet where sbilldet.qty>0 order by sbilldet.qty