Difference between revisions of "CASE"

From SQLZOO
Jump to: navigation, search
 
Line 36: Line 36:
 
   <li>[[NVL |NVL function]]</li>
 
   <li>[[NVL |NVL function]]</li>
 
</ul>
 
</ul>
 +
 +
{{Languages}}

Latest revision as of 09:29, 1 October 2012

Compatibility
CASE WHEN b1 THEN v1 END
EngineOKAlternative
ingresYes
mysqlYes
oracleYes
postgresYes
sqlserverYes

CASE

CASE allows you to return different values under different conditions.

If there no conditions match (and there is not ELSE) then NULL is returned.

  CASE WHEN condition1 THEN value1 
       WHEN condition2 THEN value2  
       ELSE def_value 
  END 
SELECT name, population
      ,CASE WHEN population<1000000 
            THEN 'small'
            WHEN population<10000000 
            THEN 'medium'
            ELSE 'large'
       END
  FROM bbc

See also

Language: English  • Deutsch
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense