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: |
2fc12692002c70078cf8f316320aa383 |
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
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> |
︙ | ︙ |