17,140
社区成员




说错了,不用加,直接用case即可.
SELECT 1,
CASE WHEN 1 = 1 THEN 2 ELSE 3 END case,
2
from dual;
/*
1 case 2
1 2 2
*/
SELECT 1,
CASE WHEN 1 = 1 THEN 2 ELSE 3 END 'case',
2
from dual;
试试这个:
SELECT 1 A,
CASE
WHEN (1 = 1) THEN
2
ELSE
3
END B,
2 C
FROM DUAL;