http://sqlzoo.net/w/index.php?title=FUNCTIONS&feed=atom&action=history
FUNCTIONS - Revision history
2013-05-25T14:24:17Z
Revision history for this page on the wiki
MediaWiki 1.20.4
http://sqlzoo.net/w/index.php?title=FUNCTIONS&diff=4193&oldid=prev
Peter at 16:50, 21 October 2012
2012-10-21T16:50:21Z
<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 16:50, 21 October 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 14:</td>
<td colspan="2" class="diff-lineno">Line 14:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[COUNT]]</td><td align='left'>[[LEFT]]</td><td align='left'>[[% MODULO]]</td><td align='left'>[[SIN]]</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'>[[COUNT]]</td><td align='left'>[[LEFT]]</td><td align='left'>[[% MODULO]]</td><td align='left'>[[SIN]]</td><td></td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CURRENT_DATE]]</td><td align='left'>[[LEN]]</td><td align='left'>[[+(dates)]]</td><td align='left'>[[SUBSTR]]</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'>[[CURRENT_DATE]]</td><td align='left'>[[LEN]]</td><td align='left'>[[+(dates)]]</td><td align='left'>[[SUBSTR]]</td><td></td></tr></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=FUNCTIONS&diff=3429&oldid=prev
Marek at 11:09, 10 August 2012
2012-08-10T11:09:15Z
<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:09, 10 August 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 1:</td>
<td colspan="2" class="diff-lineno">Line 1:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h3>SQL Functions</h3></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><h3>SQL Functions</h3></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>Standard SQL functions <del class="diffchange diffchange-inline">together with </del>some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.</div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>Standard SQL functions <ins class="diffchange diffchange-inline">and </ins>some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.</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: #eee; color:black; font-size: smaller;"><div><tr><th></th><th></th><th></th><th></th></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><th></th><th></th><th></th><th></th></tr></div></td></tr>
</table>
Marek
http://sqlzoo.net/w/index.php?title=FUNCTIONS&diff=1108&oldid=prev
Connor at 15:13, 12 July 2012
2012-07-12T15:13:57Z
<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:13, 12 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[ABS]]</td><td align='left'>[[CURRENT_TIMESTAMP]]</td><td align='left'>[[LENGTH]]</td><td align='left'>[[+ INTERVAL]]</td><td align='left'>[[SUBSTRING(ansi)]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[ABS]]</td><td align='left'>[[CURRENT_TIMESTAMP]]</td><td align='left'>[[LENGTH]]</td><td align='left'>[[+ INTERVAL]]</td><td align='left'>[[SUBSTRING(ansi)]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[AVG]]</td><td align='left'>[[DATEPART]]</td><td align='left'>[[MAX]]</td><td align='left'>[[+ (string)]]</td><td align='left'>[[SUBSTRING]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[AVG]]</td><td align='left'>[[DATEPART]]</td><td align='left'>[[MAX]]</td><td align='left'>[[+ (string)]]</td><td align='left'>[[SUBSTRING]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>[[<del class="diffchange diffchange-inline">More strings</del>]]</td><td align='left'>[[DAY]]</td><td align='left'>[[MIN]]</td><td align='left'>[[POSITION]]</td><td align='left'>[[SUM]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>[[<ins class="diffchange diffchange-inline">Strings</ins>]]</td><td align='left'>[[DAY]]</td><td align='left'>[[MIN]]</td><td align='left'>[[POSITION]]</td><td align='left'>[[SUM]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CASE]]</td><td align='left'>[[DIV]]</td><td align='left'>[[MINUTE]]</td><td align='left'>[[QUARTER]]</td><td align='left'>[[TAN]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CASE]]</td><td align='left'>[[DIV]]</td><td align='left'>[[MINUTE]]</td><td align='left'>[[QUARTER]]</td><td align='left'>[[TAN]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CAST]]</td><td align='left'>[[EXTRACT]]</td><td align='left'>[[MOD]]</td><td align='left'>[[RANK]]</td><td align='left'>[[TO_CHAR(dates)]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CAST]]</td><td align='left'>[[EXTRACT]]</td><td align='left'>[[MOD]]</td><td align='left'>[[RANK]]</td><td align='left'>[[TO_CHAR(dates)]]</td></tr></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=FUNCTIONS&diff=1107&oldid=prev
Connor at 15:13, 12 July 2012
2012-07-12T15:13:30Z
<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:13, 12 July 2012</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 5:</td>
<td colspan="2" class="diff-lineno">Line 5:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[ABS]]</td><td align='left'>[[CURRENT_TIMESTAMP]]</td><td align='left'>[[LENGTH]]</td><td align='left'>[[+ INTERVAL]]</td><td align='left'>[[SUBSTRING(ansi)]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[ABS]]</td><td align='left'>[[CURRENT_TIMESTAMP]]</td><td align='left'>[[LENGTH]]</td><td align='left'>[[+ INTERVAL]]</td><td align='left'>[[SUBSTRING(ansi)]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[AVG]]</td><td align='left'>[[DATEPART]]</td><td align='left'>[[MAX]]</td><td align='left'>[[+ (string)]]</td><td align='left'>[[SUBSTRING]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[AVG]]</td><td align='left'>[[DATEPART]]</td><td align='left'>[[MAX]]</td><td align='left'>[[+ (string)]]</td><td align='left'>[[SUBSTRING]]</td></tr></div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div><tr><td align='left'>[[<del class="diffchange diffchange-inline">|| (</del>strings<del class="diffchange diffchange-inline">)</del>]]</td><td align='left'>[[DAY]]</td><td align='left'>[[MIN]]</td><td align='left'>[[POSITION]]</td><td align='left'>[[SUM]]</td></tr></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><tr><td align='left'>[[<ins class="diffchange diffchange-inline">More </ins>strings]]</td><td align='left'>[[DAY]]</td><td align='left'>[[MIN]]</td><td align='left'>[[POSITION]]</td><td align='left'>[[SUM]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CASE]]</td><td align='left'>[[DIV]]</td><td align='left'>[[MINUTE]]</td><td align='left'>[[QUARTER]]</td><td align='left'>[[TAN]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CASE]]</td><td align='left'>[[DIV]]</td><td align='left'>[[MINUTE]]</td><td align='left'>[[QUARTER]]</td><td align='left'>[[TAN]]</td></tr></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CAST]]</td><td align='left'>[[EXTRACT]]</td><td align='left'>[[MOD]]</td><td align='left'>[[RANK]]</td><td align='left'>[[TO_CHAR(dates)]]</td></tr></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><tr><td align='left'>[[CAST]]</td><td align='left'>[[EXTRACT]]</td><td align='left'>[[MOD]]</td><td align='left'>[[RANK]]</td><td align='left'>[[TO_CHAR(dates)]]</td></tr></div></td></tr>
</table>
Connor
http://sqlzoo.net/w/index.php?title=FUNCTIONS&diff=1103&oldid=prev
Connor: Created page with "<h3>SQL Functions</h3> Standard SQL functions together with some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where..."
2012-07-12T15:08:10Z
<p>Created page with "<h3>SQL Functions</h3> Standard SQL functions together with some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where..."</p>
<p><b>New page</b></p><div><h3>SQL Functions</h3><br />
Standard SQL functions together with some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.<br />
<table><br />
<tr><th></th><th></th><th></th><th></th></tr><br />
<tr><td align='left'>[[ABS]]</td><td align='left'>[[CURRENT_TIMESTAMP]]</td><td align='left'>[[LENGTH]]</td><td align='left'>[[+ INTERVAL]]</td><td align='left'>[[SUBSTRING(ansi)]]</td></tr><br />
<tr><td align='left'>[[AVG]]</td><td align='left'>[[DATEPART]]</td><td align='left'>[[MAX]]</td><td align='left'>[[+ (string)]]</td><td align='left'>[[SUBSTRING]]</td></tr><br />
<tr><td align='left'>[[|| (strings)]]</td><td align='left'>[[DAY]]</td><td align='left'>[[MIN]]</td><td align='left'>[[POSITION]]</td><td align='left'>[[SUM]]</td></tr><br />
<tr><td align='left'>[[CASE]]</td><td align='left'>[[DIV]]</td><td align='left'>[[MINUTE]]</td><td align='left'>[[QUARTER]]</td><td align='left'>[[TAN]]</td></tr><br />
<tr><td align='left'>[[CAST]]</td><td align='left'>[[EXTRACT]]</td><td align='left'>[[MOD]]</td><td align='left'>[[RANK]]</td><td align='left'>[[TO_CHAR(dates)]]</td></tr><br />
<tr><td align='left'>[[CEIL]]</td><td align='left'>[[FLOOR]]</td><td align='left'>[[MONTH]]</td><td align='left'>[[REPLACE]]</td><td align='left'>[[TRIM]]</td></tr><br />
<tr><td align='left'>[[COALESCE]]</td><td align='left'>[[HOUR]]</td><td align='left'>[[NULLIF]]</td><td align='left'>[[RIGHT]]</td><td align='left'>[[YEAR]]</td></tr><br />
<tr><td align='left'>[[CONCAT]]</td><td align='left'>[[IFNULL]]</td><td align='left'>[[NVL]]</td><td align='left'>[[ROUND]]</td><td></td></tr><br />
<tr><td align='left'>[[COS]]</td><td align='left'>[[INSTR]]</td><td align='left'>[[PATINDEX]]</td><td align='left'>[[SECOND]]</td><td></td></tr><br />
<tr><td align='left'>[[COUNT]]</td><td align='left'>[[LEFT]]</td><td align='left'>[[% MODULO]]</td><td align='left'>[[SIN]]</td><td></td></tr><br />
<tr><td align='left'>[[CURRENT_DATE]]</td><td align='left'>[[LEN]]</td><td align='left'>[[+(dates)]]</td><td align='left'>[[SUBSTR]]</td><td></td></tr></div>
Connor