Difference between revisions of "FUNCTIONS"
From SQLZOO
| 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.
