Documentation Source Text

Check-in [2fc1269200]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Add documentation for the group_concat() function.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 2fc12692002c70078cf8f316320aa3836665293f
User & Date: drh 2007-11-28 22:22:03.000
Context
2007-11-30
01:05
Add code to the sqlite3.h reader to ignore function requirement numbers embedded in the text. (check-in: 06172b7a6f user: drh tags: trunk)
2007-11-28
22:22
Add documentation for the group_concat() function. (check-in: 2fc1269200 user: drh tags: trunk)
18:38
Fix typos on the docs.html page of the website. CVSTrac ticket #2811. (check-in: d6475c6071 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/lang.in.
︙︙
1504
1505
1506
1507
1508
1509
1510









1511
1512
1513
1514
1515
1516
1517

<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>








>
>
>
>
>
>
>
>
>








1504
1505
1506
1507
1508
1509
1510
1511
1512
1513
1514
1515
1516
1517
1518
1519
1520
1521
1522
1523
1524
1525
1526

<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 of
all non-NULL values of <i>X</i>.  If parameter <i>Y</i> is the separator
between instances of <i>X</i>.  A comma (",") is used as the separator
if <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>
︙︙