select ziduan1,
ziduan2,
(select sum(ziduan1+ziduan2) from tables) as newzd12,
ziduan3,
ziduan4,
(select sum(ziduan3+ziduan4) from tables)
from tables
ziduan2,
(select sum(ziduan1+ziduan2) from tables) as newzd12,
ziduan3,
ziduan4,
(select sum(ziduan3+ziduan4) from tables)
from tables
select ziduan1,
ziduan2,
(ziduan1+ziduan2) as newzd12,
ziduan3,
ziduan4,
(ziduan3+ziduan4) as newzd34
from tables
或是所有行的求和:
select ziduan1,
ziduan2,
(select sum(ziduan1+ziduan2) from tables) as newzd12,
ziduan3,
ziduan4,
(select sum(ziduan3+ziduan4) from tables)as newzd34
from tables