casewhen用法oracle

数据运维 2023-08-04 LOVEHL^ˇ^ 手机阅读

SELECT column1 FROM table1 WHERE CASE WHEN column2 >50 THEN 1 WHEN column2

CASE表达式在有时也可以被用来实现简单的逻辑：

SELECT column1, CASE column2 WHEN 1 THEN 'One' WHEN 2 THEN 'Two' WHEN 3 THEN 'Three' ELSE 'Other' END FROM table1;