Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add documentation for the group_concat() function. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
2fc12692002c70078cf8f316320aa383 |
| User & Date: | drh 2007-11-28 22:22:03 |
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
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> |