我想把統計的數據放在最後一行，這個SQL咋寫？拜托，沒分了。

[gallardo]

一表:
ID Storage Qty
-----------------------
01 A 21
01 B 10

SQL查詢後
ID Storage Qty
-----------------------
01 A 21
01 B 10
01 Tatal: 31

[pengdali]

select * from 一表
union all
select id,'tatal:',sum(qyt) from 一表 group by id

[yujohny]

select * from
(select * from 一表
union all
select id,'tatal:',sum(qyt) from 一表 group by id)
order by id