在Oracle里面SQL的问题！！！急急急

[qkaizhou]

原来在SQLServer里面的SQL文如下
SELECT IIf([A]>[B],"*","") AS 判定
FROM Table

就是[A]>[B]取值“*”否则“”
在Oracle里面如何实现？？？？？？
谢谢！！！！！！！

[qkaizhou]

再问一下：
SELECT A,B,C,IIf(Table1.A>Table1.B,"*","") AS 判定
from Table1,Table2
Where Table1.A=Table2.A

改为：
SELECT A,B,C,（SELECT CASE WHEN Table1.A>Table1.B THEN '*' ELSE '' END FROM Table1,Table2
Where Table1.A=Table2.A)"判定"
from Table1,Table2
Where Table1.A=Table2.A

还是：
SELECT A,B,C,（SELECT CASE WHEN Table1.A>Table1.B THEN '*' ELSE '' END )"判定"
from Table1,Table2
Where Table1.A=Table2.A

谢谢！

[ATCG]

select decode(greatest(A,B),A,'*','') from table;

[qkaizhou]

还是：
SELECT A,B,C,（CASE WHEN Table1.A>Table1.B THEN '*' ELSE '' END )"判定"
from Table1,Table2
Where Table1.A=Table2.A

[左格]

第一个

[qkaizhou]

谢谢！

[zhoubf725]

decode

[ATCG]

select decode(基本值,和基本值比较的值,为真得出值,为假得出值)
from table;

[qkaizhou]

但我要比较大小，因该如何做阿？谢谢！

[zm1616]

select case
when A > B then '*' else '' end,
when A <= C then '#' else '*' end
from table

应该是OK的，我、昨天刚这么写过，呵呵

[zm1616]

select case
when A > B then '*' else '' end,
when A <= C then '#' else '*' end
from table

应该是OK的，我、昨天刚这么写过，呵呵

[black_dragon]

SELECT DECODE(SIGN(A-B),1,'*','') FROM TABLENNAME;