http://www.sqlzoo.net/w/index.php?title=CASE&feed=atom&action=history
CASE - Revision history
2013-05-23T10:47:06Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://www.sqlzoo.net/w/index.php?title=CASE&diff=4107&oldid=prev
77.188.26.13 at 09:29, 1 October 2012
2012-10-01T09:29:13Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 09:29, 1 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 36:</td>
<td colspan="2" class="diff-lineno">Line 36:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[NVL |NVL function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[NVL |NVL function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;"></ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">{{Languages}}</ins></div></td></tr>
</table>
77.188.26.13
http://www.sqlzoo.net/w/index.php?title=CASE&diff=1347&oldid=prev
Connor at 14:35, 16 July 2012
2012-07-16T14:35:02Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:35, 16 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 34:</td>
<td colspan="2" class="diff-lineno">Line 34:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>See also</p></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><ul></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   <li>[[NVL function]]</li></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   <li>[[<ins class="diffchange diffchange-inline">NVL |</ins>NVL function]]</li></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></ul></div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=CASE&diff=1171&oldid=prev
Connor at 10:56, 13 July 2012
2012-07-13T10:56:38Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 10:56, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 9:</td>
<td colspan="2" class="diff-lineno">Line 9:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></table></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><<del class="diffchange diffchange-inline">h3</del>>CASE</<del class="diffchange diffchange-inline">h3</del>></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><<ins class="diffchange diffchange-inline">h1</ins>>CASE</<ins class="diffchange diffchange-inline">h1</ins>></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>CASE allows you to return different values under different conditions. </p></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>CASE allows you to return different values under different conditions. </p></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>If there no conditions match (and there is not ELSE) then NULL is returned.</p>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p>If there no conditions match (and there is not ELSE) then NULL is returned.</p>  </div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=CASE&diff=1161&oldid=prev
Connor at 10:45, 13 July 2012
2012-07-13T10:45:32Z
<p></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr style='vertical-align: top;'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 10:45, 13 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 22:</td>
<td colspan="2" class="diff-lineno">Line 22:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, population</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, population</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>       ,CASE WHEN population<1000000 THEN 'small'</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>       ,CASE WHEN population<1000000  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>             WHEN population<10000000 THEN 'medium'</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">            </ins>THEN 'small'</div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>             WHEN population<10000000  </div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">            </ins>THEN 'medium'</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>             ELSE 'large'</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>             ELSE 'large'</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       END</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       END</div></td></tr>
</table>
Connor
http://www.sqlzoo.net/w/index.php?title=CASE&diff=1160&oldid=prev
Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CASE WHEN b1 THEN v1 END</th></tr> <tr><td align='center'>'''Engine'''</td><td align='cen..."
2012-07-13T10:45:01Z
<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>CASE WHEN b1 THEN v1 END</th></tr> <tr><td align='center'>'''Engine'''</td><td align='cen..."</p>
<p><b>New page</b></p><div><table align='right' border='1'><br />
<caption>Compatibility</caption><br />
<tr><th colspan='3'>CASE WHEN b1 THEN v1 END</th></tr><br />
<tr><td align='center'>'''Engine'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br />
<tr><td align='left'>ingres</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>mysql</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>oracle</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>postgres</td><td>Yes</td><td></td></tr><br />
<tr><td align='left'>sqlserver</td><td>Yes</td><td></td></tr><br />
</table><br />
<h3>CASE</h3><br />
<p>CASE allows you to return different values under different conditions. </p><br />
<p>If there no conditions match (and there is not ELSE) then NULL is returned.</p> <br />
<pre style='width:50ex'><br />
CASE WHEN condition1 THEN value1 <br />
WHEN condition2 THEN value2 <br />
ELSE def_value <br />
END <br />
</pre><br />
<br />
<div class='qu'> <br />
<source lang='sql' class='def'><br />
SELECT name, population<br />
,CASE WHEN population<1000000 THEN 'small'<br />
WHEN population<10000000 THEN 'medium'<br />
ELSE 'large'<br />
END<br />
FROM bbc<br />
</source><br />
</div><br />
<br />
<p>See also</p><br />
<ul><br />
<li>[[NVL function]]</li><br />
</ul></div>
Connor