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

原来在SQLServer里面的SQL文如下
SELECT IIf([A]>[B],"*","") AS 判定
FROM Table
就是[A]>[B]取值“*”否则“”
在Oracle里面如何实现？？？？？？
谢谢!!!!

[163 byte] By [qkaizhou-御赐金牌小密探！] at [2008-6-5]

«« 关于软件皮肤方面的问题
»» 提个treeview的小问题

# 1

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

ATCG-novelgene at 2007-10-28 >

# 2

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

qkaizhou-御赐金牌小密探！ at 2007-10-28 >

# 3

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

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

zm1616-拳皇77 at 2007-10-28 >

# 4

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

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

zm1616-拳皇77 at 2007-10-28 >

# 5

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

black_dragon-半仙 at 2007-10-28 >

# 6

再问一下：
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

谢谢!

qkaizhou-御赐金牌小密探！ at 2007-10-28 >

# 7

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

ATCG-novelgene at 2007-10-28 >

# 8

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

qkaizhou-御赐金牌小密探！ at 2007-10-28 >

# 9

第一个

zergwang-神游 at 2007-10-28 >

# 10

谢谢!