<tr>
<td valign="top" align="right">count(<i>X</i>)<br>count(*)</td>
<td valign="top">The first form return a count of the number of times
that <i>X</i> is not NULL in a group. The second form (with no argument)
returns the total number of rows in the group.</td>
</tr>
<tr>
<td valign="top" align="right">max(<i>X</i>)</td>
<td valign="top">Return the maximum value of all values in the group.
The usual sort order is used to determine the maximum.</td>
</tr>
<tr>

<tr>
<td valign="top" align="right">count(<i>X</i>)<br>count(*)</td>
<td valign="top">The first form return a count of the number of times
that <i>X</i> is not NULL in a group. The second form (with no argument)
returns the total number of rows in the group.</td>
</tr>
<tr><td valign="top" align="right">group_concat(<i>X</i>)<br>group_concat(<i>X</i>,<i>Y</i>)</td><td valign="top">The result is a string which is the concatenation ofall non-NULL values of <i>X</i>. If parameter <i>Y</i> is the separatorbetween instances of <i>X</i>. A comma (",") is used as the separatorif <i>Y</i> is omitted.</td></tr>
<tr>
<td valign="top" align="right">max(<i>X</i>)</td>
<td valign="top">Return the maximum value of all values in the group.
The usual sort order is used to determine the maximum.</td>
</tr>
<tr>

This page was generated in about
0.014s by
Fossil 2.10 [b94e15cff7] 2019-09-13 13:54:36