select case when A > B then '*' else '' end, when A <= C then '#' else '*' end from table应该是OK的,我、昨天刚这么写过,呵呵
select case when A > B then '*' else '' end, when A <= C then '#' else '*' end from table应该是OK的,我、昨天刚这么写过,呵呵
SELECT DECODE(SIGN(A-B),1,'*','') FROM TABLENNAME;
再问一下: 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谢谢!
select decode(greatest(A,B),A,'*','') from table;
还是: SELECT A,B,C,(CASE WHEN Table1.A>Table1.B THEN '*' ELSE '' END )"判定" from Table1,Table2 Where Table1.A=Table2.A
when A > B then '*' else '' end,
when A <= C then '#' else '*' end
from table应该是OK的,我、昨天刚这么写过,呵呵
when A > B then '*' else '' end,
when A <= C then '#' else '*' end
from table应该是OK的,我、昨天刚这么写过,呵呵
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谢谢!
SELECT A,B,C,(CASE WHEN Table1.A>Table1.B THEN '*' ELSE '' END )"判定"
from Table1,Table2
Where Table1.A=Table2.A