IFNULL - Revision history

http://sqlzoo.net/w/index.php?title=IFNULL&feed=atom&action=history IFNULL - Revision history 2013-05-19T14:09:21Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=IFNULL&diff=4260&oldid=prev Peter at 20:24, 22 October 2012 2012-10-22T20:24:09Z

<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 20:24, 22 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 13:</td> <td colspan="2" class="diff-lineno">Line 13:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p></p>  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><p></p>  </div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre style='width:60ex'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><pre style='width:60ex'></div></td></tr> <tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><del class="diffchange diffchange-inline">    </del>IFNULL(x,y) = x if x is not NULL</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins class="diffchange diffchange-inline">  </ins>IFNULL(x,y) = x if x is not NULL</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   IFNULL(x,y) = y if x is NULL</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   IFNULL(x,y) = y if x is NULL</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></pre></div></td></tr> </table>

Peter http://sqlzoo.net/w/index.php?title=IFNULL&diff=4259&oldid=prev Peter at 20:21, 22 October 2012 2012-10-22T20:21:27Z

<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 20:21, 22 October 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 48:</td> <td colspan="2" class="diff-lineno">Line 48:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[CASE |CASE function]]</li></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   <li>[[CASE |CASE 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>

Peter http://sqlzoo.net/w/index.php?title=IFNULL&diff=1371&oldid=prev Connor at 15:01, 16 July 2012 2012-07-16T15:01:06Z

<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 15:01, 16 July 2012</td> </tr><tr><td colspan="2" class="diff-lineno">Line 30:</td> <td colspan="2" class="diff-lineno">Line 30:</td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,IFNULL(party,'None') AS aff</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>       ,IFNULL(party,'None') AS aff</div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM msp WHERE name LIKE 'C%'</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM msp WHERE name LIKE 'C%'</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;"></source></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;"><source lang='sql' class='def e-oracle'></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;">SELECT name, party</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;">      ,COALESCE(party,'None') AS aff</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;">  FROM gisq.msp WHERE name LIKE 'C%'</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div></source></div></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> </table>

Connor http://sqlzoo.net/w/index.php?title=IFNULL&diff=1308&oldid=prev Connor: Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>IFNULL(f1, f2)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK..." 2012-07-16T12:02:00Z

<p>Created page with "<table align='right' border='1'> <caption>Compatibility</caption> <tr><th colspan='3'>IFNULL(f1, f2)</th></tr> <tr><td align='center'>'''Engine'''</td><td align='center'>'''OK..."</p> <p><b>New page</b></p><div><table align='right' border='1'><br /> <caption>Compatibility</caption><br /> <tr><th colspan='3'>IFNULL(f1, f2)</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>[[COALESCE |COALESCE(f1, f2)]]</td></tr><br /> <tr><td align='left'>mysql</td><td>Yes</td><td>[[COALESCE |COALESCE(f1, f2)]]</td></tr><br /> <tr><td align='left'>oracle</td><td>No</td><td>[[COALESCE |COALESCE(f1, f2)]]</td></tr><br /> <tr><td align='left'>postgres</td><td>No</td><td>[[COALESCE |COALESCE(f1, f2)]]</td></tr><br /> <tr><td align='left'>sqlserver</td><td>No</td><td>[[COALESCE |COALESCE(f1, f2)]]</td></tr><br /> </table><br /> <h1>IFNULL</h1><br /> <p>IFNULL takes two arguments and returns the first value that is not null.</p><br /> <p></p> <br /> <pre style='width:60ex'><br /> IFNULL(x,y) = x if x is not NULL<br /> IFNULL(x,y) = y if x is NULL<br /> </pre><br /> <br /> <div class='ht'><br /> IFNULL can be useful when you want to replace a NULL value with some other value. <br /> In this example you show the name of the party for each MSP that has a party. <br /> For the MSP with no party (such as Canavan, Dennis) you show the string None. <br /> <source lang='sql' class='def e-ingres'><br /> SELECT name, party<br /> ,IFNULL(party,'None') AS aff<br /> FROM msp WHERE name LIKE 'C%'<br /> </source><br /> <source lang='sql' class='def e-mysql'><br /> SELECT name, party<br /> ,IFNULL(party,'None') AS aff<br /> FROM msp WHERE name LIKE 'C%'<br /> </source><br /> <source lang='sql' class='def'><br /> SELECT name, party<br /> ,COALESCE(party,'None') AS aff<br /> FROM msp WHERE name LIKE 'C%'<br /> </source><br /> </div><br /> <br /> <p>See also</p><br /> <ul><br /> <li>[[COALESCE |COALESCE function]]</li><br /> <li>[[CASE |CASE function]]</li><br /> </ul></div>

Connor