也可以这样 select case when (A1-A2)>0 then 'true' else 'false' end from table;
up ATGC的。 dinya2003的sql恐怕需要改进,A1=A2时应该返回FALSE而不是0: select a1,a2,decode(sign(A1-a2),1,'True','False') from tablename;
谢谢各位的关注,在此谢谢大家了,我使用的是decode方法.调试已经通过,我把我的sql语句帖出来,自我感觉有些复杂了,是否会影响速度?如何改进比较好呢?而且我使用的都是外连接,因为我们的程序不希望连接不到的时候丢失显示的数据. Select zl1101,zl0104 zl1102ID,sc0202 zl1102,zl1103 zl1103ID,zl0102 zl1103,zl1104,gy2203,gy2204,decode(sign(abs(gy2203-zl1104)-gy2204),1,'是',-1,'否',1) From (Select * From (Select * From (Select * From zl011 Left Outer Join zl001 On zl1103=zl0101) zl011 Left Outer Join sc004 On zl0104=sc0404 And zl1101 Between nvl(sc0402,Sysdate) And nvl(sc0403,Sysdate)) zl1101 Left Outer Join gy022 On sc0410=gy2201 And zl0105=gy2202) zl011 Left Outer Join sc002 On zl0104=sc0201
select case when (A1-A2)>0 then 'true' else 'false' end from table;
dinya2003的sql恐怕需要改进,A1=A2时应该返回FALSE而不是0:
select a1,a2,decode(sign(A1-a2),1,'True','False') from tablename;
Select zl1101,zl0104 zl1102ID,sc0202 zl1102,zl1103 zl1103ID,zl0102 zl1103,zl1104,gy2203,gy2204,decode(sign(abs(gy2203-zl1104)-gy2204),1,'是',-1,'否',1) From (Select * From (Select * From (Select * From zl011 Left Outer Join zl001 On zl1103=zl0101) zl011 Left Outer Join sc004 On zl0104=sc0404 And zl1101 Between nvl(sc0402,Sysdate) And nvl(sc0403,Sysdate)) zl1101 Left Outer Join gy022 On sc0410=gy2201 And zl0105=gy2202) zl011 Left Outer Join sc002 On zl0104=sc0201