http://sqlzoo.net/w/index.php?title=IFNULL/de&feed=atom&action=historyIFNULL/de - Revision history2013-06-19T19:48:55ZRevision history for this page on the wikiMediaWiki 1.20.4http://sqlzoo.net/w/index.php?title=IFNULL/de&diff=4369&oldid=prevPeter at 11:53, 28 October 20122012-10-28T11:53:36Z<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 11:53, 28 October 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>IFNULL ist nützlich, um einen NULL-Wert durch einen anderen Wert zu ersetzen.  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>IFNULL ist nützlich, um einen NULL-Wert durch einen anderen Wert zu ersetzen.  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In diesem Beispiel wird der Name der Partei jedes Mitglieds des Schottischen Parlamentes (MSP) ermittelt, sofern ein Wert gespeichert ist.  </div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>In diesem Beispiel wird der Name der Partei jedes Mitglieds des Schottischen Parlamentes (MSP) ermittelt, sofern ein Wert gespeichert ist.  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Für alle MSP ohne Partei (z.B. Canavan, Dennis) wird die Zeichenkette "<del class="diffchange diffchange-inline">None</del>" ausgegeben.   </div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Für alle MSP ohne Partei (z.B. Canavan, Dennis) wird die Zeichenkette "<ins class="diffchange diffchange-inline">Keine</ins>" ausgegeben.   </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-ingres'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-ingres'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, party</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, party</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>       ,IFNULL(party,'<del class="diffchange diffchange-inline">None</del>') AS aff</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>       ,IFNULL(party,'<ins class="diffchange diffchange-inline">Keine</ins>') 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 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 e-mysql'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-mysql'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, party</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, party</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>       ,IFNULL(party,'<del class="diffchange diffchange-inline">None</del>') AS aff</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>       ,IFNULL(party,'<ins class="diffchange diffchange-inline">Keine</ins>') 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 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 e-oracle'></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><source lang='sql' class='def e-oracle'></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, party</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, party</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>       ,COALESCE(party,'<del class="diffchange diffchange-inline">None</del>') AS aff</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>       ,COALESCE(party,'<ins class="diffchange diffchange-inline">Keine</ins>') AS aff</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM gisq.msp WHERE name LIKE 'C%'</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>   FROM gisq.msp WHERE name LIKE 'C%'</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>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, party</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>SELECT name, party</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>       ,COALESCE(party,'<del class="diffchange diffchange-inline">None</del>') AS aff</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>       ,COALESCE(party,'<ins class="diffchange diffchange-inline">Keine</ins>') 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 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>
</table>Peterhttp://sqlzoo.net/w/index.php?title=IFNULL/de&diff=4368&oldid=prevPeter at 11:53, 28 October 20122012-10-28T11:53:07Z<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 11:53, 28 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 15:</td>
<td colspan="2" class="diff-lineno">Line 15:</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>   IFNULL(x,y) = x <del class="diffchange diffchange-inline">if </del>x <del class="diffchange diffchange-inline">is not </del>NULL</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   IFNULL(x,y) = x<ins class="diffchange diffchange-inline">, wenn </ins>x <ins class="diffchange diffchange-inline">nicht </ins>NULL <ins class="diffchange diffchange-inline">ist</ins></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>   IFNULL(x,y) = y <del class="diffchange diffchange-inline">if </del>x <del class="diffchange diffchange-inline">is </del>NULL</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>   IFNULL(x,y) = y<ins class="diffchange diffchange-inline">, wenn </ins>x NULL <ins class="diffchange diffchange-inline">ist</ins></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>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
</table>Peterhttp://sqlzoo.net/w/index.php?title=IFNULL/de&diff=4261&oldid=prevPeter: Created page with "Category:Deutsch <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>IFNULL(f1, f2)</th></tr> <tr><td align='center'>'''DBMS'''</td><td..."2012-10-22T20:29:42Z<p>Created page with "<a href="/wiki/Category:Deutsch" title="Category:Deutsch">Category:Deutsch</a> <table align='right' border='1'> <caption>Kompatibilität</caption> <tr><th colspan='3'>IFNULL(f1, f2)</th></tr> <tr><td align='center'>'''DBMS'''</td><td..."</p>
<p><b>New page</b></p><div>[[Category:Deutsch]]<br />
<table align='right' border='1'><br />
<caption>Kompatibilität</caption><br />
<tr><th colspan='3'>IFNULL(f1, f2)</th></tr><br />
<tr><td align='center'>'''DBMS'''</td><td align='center'>'''OK'''</td><td align='center'>'''Alternative'''</td></tr><br />
<tr><td align='left'>Ingres</td><td>Ja</td><td>[[COALESCE/de | COALESCE(f1, f2)]]</td></tr><br />
<tr><td align='left'>MySQL</td><td>Ja</td><td>[[COALESCE/de | COALESCE(f1, f2)]]</td></tr><br />
<tr><td align='left'>Oracle</td><td>Nein</td><td>[[COALESCE/de | COALESCE(f1, f2)]]</td></tr><br />
<tr><td align='left'>PostgreSQL</td><td>Nein</td><td>[[COALESCE/de | COALESCE(f1, f2)]]</td></tr><br />
<tr><td align='left'>SQL Server</td><td>Nein</td><td>[[COALESCE/de | COALESCE(f1, f2)]]</td></tr><br />
</table><br />
<br />
<h1>IFNULL</h1><br />
<p>IFNULL liefert den ersten Wert von zwei Argumenten, der nicht NULL ist.</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 ist nützlich, um einen NULL-Wert durch einen anderen Wert zu ersetzen. <br />
In diesem Beispiel wird der Name der Partei jedes Mitglieds des Schottischen Parlamentes (MSP) ermittelt, sofern ein Wert gespeichert ist. <br />
Für alle MSP ohne Partei (z.B. Canavan, Dennis) wird die Zeichenkette "None" ausgegeben. <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 e-oracle'><br />
SELECT name, party<br />
,COALESCE(party,'None') AS aff<br />
FROM gisq.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>Siehe auch</p><br />
<ul><br />
<li>[[COALESCE/de | Funktion COALESCE]]</li><br />
<li>[[CASE/de | Funktion CASE]]</li><br />
</ul><br />
<br />
{{Languages}}</div>Peter