symbol TradeVolume
MSFT 100
IBM 200
MSFT 200
IBM 50
IBM 150
How to find the difference between MSFT and IBM trade volume
谢谢各位大牛解答！
a9 发帖数: 21638
2
差？
select (select sum(tradevolume) from table where symbol='MSFT')-(select sum(
tradevolume) from table where symbol='ibm')
【在 w*********8 的大作中提到】 : symbol TradeVolume : MSFT 100 : IBM 200 : MSFT 200 : IBM 50 : IBM 150 : How to find the difference between MSFT and IBM trade volume : 谢谢各位大牛解答！
