Connor at 14:59, 17 July 2012

2012-07-17T14:59:20Z

Connor at 14:58, 17 July 2012

2012-07-17T14:58:52Z

Connor: Created page with "Conditional values

schema:gisq

The SQL Standard is the CASE statement
..."

2012-07-17T14:58:03Z

Created page with "Conditional values <div class='ht'> <div class=params>schema:gisq</div> <div> The SQL Standard is the CASE statement </div> <source lang=sql class='tidy'> </source> ..."

New page

Conditional values
<div class='ht'>
<div class=params>schema:gisq</div>
<div>
The SQL Standard is the [[CASE |CASE]] statement
</div>
<source lang=sql class='tidy'>
</source>
<source lang=sql class='setup'></source>
<source lang='sql' class='def e-access'>SELECT title,
score,
IIF(score>8.5,'Excellent','OK')
FROM movie
WHERE 10>id</source>
<source lang='sql' class='def e-sqlserver'>SELECT title, score,
CASE
WHEN score>8.5 THEN 'Excellent'
ELSE 'OK'
END
FROM movie
WHERE 10>id</source>
<source lang='sql' class='def e-oracle'>SELECT
title,
score,
CASE WHEN score>8.5 THEN 'Excellent'
ELSE 'OK'
END
FROM gisq.movie
WHERE 10>id</source>
<source lang='sql' class='def'>SELECT
title,
score,
CASE WHEN score>8.5 THEN 'Excellent'
ELSE 'OK'
END
FROM movie
WHERE 10>id</source>

<div class="ecomm e-postgres" style="display: none">Any number of cases may be used.</div>
<div class="ecomm e-oracle" style="display: none">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</div>
<div class="ecomm e-mysql" style="display: none">The IF function is also available:
SELECT title,
score,
IF(score>8.5,'Excellent','OK')
FROM movie
WHERE 10>id</div>
</div>
{{Functions ref}}

@@ Line 34: / Line 34: @@
          ELSE 'OK'
     END
-    FROM gisq.movie
+    FROM movie
     WHERE 10>id</source>

Conditional values - Revision history

Connor at 14:59, 17 July 2012

Connor at 14:58, 17 July 2012

Connor: Created page with "Conditional values schema:gisq The SQL Standard is the CASE statement ..."

Connor: Created page with "Conditional values

schema:gisq

The SQL Standard is the CASE statement
..."