Difference between revisions of "Conditional values"

Latest revision as of 14:59, 17 July 2012

Conditional values

schema:gisq

The SQL Standard is the CASE statement

SELECT title, 
       score,
       IIF(score>8.5,'Excellent','OK')
   FROM movie
   WHERE 10>id

SELECT title, score,
  CASE
    WHEN score>8.5 THEN 'Excellent'
    ELSE 'OK'
  END
FROM movie
WHERE 10>id

SELECT
   title, 
   score,
   CASE WHEN score>8.5 THEN 'Excellent'
        ELSE 'OK'
   END
   FROM gisq.movie
   WHERE 10>id

SELECT
   title, 
   score,
   CASE WHEN score>8.5 THEN 'Excellent'
        ELSE 'OK'
   END
   FROM movie
   WHERE 10>id

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

The IF function is also available:

SELECT title, 
      score,
      IF(score>8.5,'Excellent','OK')
  FROM movie

WHERE 10>id

Conditional values

Time now

Revision as of 14:58, 17 July 2012 (edit) Connor (Talk \| contribs) (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> ...")	Latest revision as of 14:59, 17 July 2012 (edit) (undo) Connor (Talk \| contribs)
(One intermediate revision by one user not shown)