数据库合并问题(0分)

W

wutaoqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-07-16

• #1

select sum(A) from Table where id='123' and FLAG='+'
select sum(A) from Table where ID='123' and FLAG='-'
--怎么将 这2个语句合并?? 把第1条查出的结果 - 第2条查出的结果

 

A

andrew57

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-07-16

• #2

declare @rt float
set @rt=0
set @rt=(select sum(A) from Table where id='123' and FLAG='+')-(select sum(A) from Table where ID='123' and FLAG='-')
print @rt

 

K

kql

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-07-16

• #3

select sum(A) from Table where (id='123' and FLAG='+')or (where ID='123' and FLAG='-'
)

 

W

wutaoqing

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-07-17

• #4

[^]谢谢