« MySQL/Fonctions » : différence entre les versions
Contenu supprimé Contenu ajouté
Aucun résumé des modifications |
|||
Ligne 219 :
</source>
===MAX(
MAX() can be used to get the maximum value for an expression in the rows matching to a query. If no row matches the query, returns NULL.
<source lang=sql>
Ligne 226 :
</source>
===MIN(
MIN() can be used to get the minimum value for an expression in the rows matching to a query. If no row matches the query, returns NULL.
<source lang=sql>
Ligne 232 :
</source>
===AVG(
AVG() can be used to get the average value for an expression in the rows matching to a query. If no row matches the query, returns NULL.
<source lang=sql>
Ligne 238 :
</source>
===SUM(
SUM() can be used to get the sum of the values for an expression in the rows matching to a query. If no row matches the query, returns NULL.
Ligne 246 :
</source>
===GROUP_CONCAT(
GROUP_CONCAT() can be used to concatenate values from all records for a group into a single string separated by comma or any additional token you like.
|