SQLzoo: Conditional values

Oracle

The SQL Standard is the CASE statement

Specific to Oracle

The DECODE function is also available:

SELECT title, 
       score,
       DECODE(SIGN(score-8.5),
              1,  'Excellent',
	      0,  'OK',
	      -1, 'OK')
   FROM movie
   WHERE 10>id

SQLite
The SQL Standard is the CASE statement	SELECT title, score, CASE WHEN score>8.5 THEN 'Excellent' ELSE 'OK' END FROM movie WHERE 10>id
Specific to SQLite
none

DB2
The SQL Standard is the CASE statement	SELECT title, score, CASE WHEN score>8.5 THEN 'Excellent' ELSE 'OK' END FROM movie WHERE 10>id
Specific to DB2
none

MS Access
The SQL Standard is the CASE statement	SELECT title, score, IIF(score>8.5,'Excellent','OK') FROM movie WHERE 10>id
Specific to MS Access
none

PostgreSQL
The SQL Standard is the CASE statement	SELECT title, score, CASE WHEN score>8.5 THEN 'Excellent' ELSE 'OK' END FROM movie WHERE 10>id
Specific to PostgreSQL
Any number of cases may be used.

MS SQL Server
The SQL Standard is the CASE statement	SELECT title, score, CASE WHEN score>8.5 THEN 'Excellent' ELSE 'OK' END FROM movie WHERE 10>id
Specific to MS SQL Server
none

MySQL
The SQL Standard is the CASE statement	SELECT title, score, CASE WHEN score>8.5 THEN 'Excellent' ELSE 'OK' END FROM movie WHERE 10>id
Specific to MySQL
The IF function is also available: SELECT title, score, IF(score>8.5,'Excellent','OK') FROM movie WHERE 10>id

Sybase
The SQL Standard is the CASE statement	SELECT title, score, CASE WHEN score>8.5 THEN 'Excellent' ELSE 'OK' END FROM movie WHERE 10>id
Specific to Sybase
none

Mimer SQL
The SQL Standard is the CASE statement	SELECT title, score, CASE WHEN score>8.5 THEN 'Excellent' ELSE 'OK' END FROM movie WHERE 10>id
Specific to Mimer SQL
none

Eine Einführung in SQL

Conditional values

Eine Einführung in

SQL