handy Mysql functions

<code><span class="pln">AVG</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> the average value </span><span class="kwd">of</span><span class="pln"> the argument
BIT_AND</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> bitwise </span><span class="kwd">and</span><span class="pln">
BIT_OR</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> bitwise </span><span class="kwd">or</span><span class="pln">
BIT_XOR</span><span class="pun">()(</span><span class="pln">v4</span><span class="lit">.1.1</span><span class="pun">)</span><span class="kwd">Return</span><span class="pln"> bitwise xor
COUNT</span><span class="pun">(</span><span class="kwd">DISTINCT</span><span class="pun">)</span><span class="kwd">Return</span><span class="pln"> the count </span><span class="kwd">of</span><span class="pln"> a number </span><span class="kwd">of</span><span class="pln"> different </span><span class="kwd">values</span><span class="pln">
COUNT</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> a count </span><span class="kwd">of</span><span class="pln"> the number </span><span class="kwd">of</span><span class="kwd">rows</span><span class="pln"> returned
GROUP_CONCAT</span><span class="pun">()(</span><span class="pln">v4</span><span class="lit">.1</span><span class="pun">)</span><span class="kwd">Return</span><span class="pln"> a concatenated string
MAX</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> the maximum value
MIN</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> the minimum value
STD</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> the population standard deviation
STDDEV_POP</span><span class="pun">()(</span><span class="pln">v5</span><span class="lit">.0.3</span><span class="pun">)</span><span class="kwd">Return</span><span class="pln"> the population standard deviation
STDDEV_SAMP</span><span class="pun">()(</span><span class="pln">v5</span><span class="lit">.0.3</span><span class="pun">)</span><span class="kwd">Return</span><span class="pln"> the sample standard deviation
STDDEV</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> the population standard deviation
SUM</span><span class="pun">()</span><span class="kwd">Return</span><span class="pln"> the sum
VAR_POP</span><span class="pun">()(</span><span class="pln">v5</span><span class="lit">.0.3</span><span class="pun">)</span><span class="kwd">Return</span><span class="pln"> the population standard variance
VAR_SAMP</span><span class="pun">()(</span><span class="pln">v5</span><span class="lit">.0.3</span><span class="pun">)</span><span class="kwd">Return</span><span class="pln"> the sample variance
VARIANCE</span><span class="pun">()(</span><span class="pln">v4</span><span class="lit">.1</span><span class="pun">)</span><span class="kwd">Return</span><span class="pln"> the population standard variance</span></code>

You may also like...