Difference between revisions of "FUNCTIONS"
From SQLZOO
(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...") |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
<h3>SQL Functions</h3> | <h3>SQL Functions</h3> | ||
| − | Standard SQL functions | + | Standard SQL functions and some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given. |
<table> | <table> | ||
<tr><th></th><th></th><th></th><th></th></tr> | <tr><th></th><th></th><th></th><th></th></tr> | ||
<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> | <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> | ||
<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> | <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> | ||
| − | <tr><td align='left'>[[ | + | <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> |
<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> | <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> | ||
<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> | <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> | ||
| Line 14: | Line 14: | ||
<tr><td align='left'>[[COUNT]]</td><td align='left'>[[LEFT]]</td><td align='left'>[[% MODULO]]</td><td align='left'>[[SIN]]</td><td></td></tr> | <tr><td align='left'>[[COUNT]]</td><td align='left'>[[LEFT]]</td><td align='left'>[[% MODULO]]</td><td align='left'>[[SIN]]</td><td></td></tr> | ||
<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> | <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> | ||
| + | |||
| + | {{Languages}} | ||
Latest revision as of 16:50, 21 October 2012
SQL Functions
Standard SQL functions and some common non-standard function. MS SQL, Oracle, MySQL and PostgreSQL provide support or have alternatives. Where possible alternatives are given.
