我有一个表AAA,如下,要用的三个字段为number,fee1,fee2.其中number为字符型,其他两个为数字型.现在要把所有sum(fee1)-sum(fee2)<0的number检索出来,我用下面的语句不行:
sql="select number from aaa compute sum(fee1)-sum(fee2)<0"
请高手帮忙!万分感谢!
...全文
7216打赏收藏
一个SQL语句,请DX帮帮.在线等..................
我有一个表AAA,如下,要用的三个字段为number,fee1,fee2.其中number为字符型,其他两个为数字型.现在要把所有sum(fee1)-sum(fee2)<0的number检索出来,我用下面的语句不行: sql="select number from aaa compute sum(fee1)-sum(fee2)<0" 请高手帮忙!万分感谢!
to lovehwq21(winson)
另外一种写法而已,效率上是前者高一些.
但是灵活性上是后者高一些
比如说下面的变形用group实现就没这么简洁,且效率会低得多
select number,feel1,feel2 from AAA
where (select sum(B.fee1)-sum(B.fee2) from AAA B WHERE B.number=AAA.number)<0
sql="select number from AAA group by number having sum(fee1)-sum(fee2)<0 "
或者直接这样写
sql="select number from AAA group by number having sum(fee1)<sum(fee2)"