Vidéos
https://www.postgresql.org › docs › current › functions-aggregate.htm
PostgreSQL: Documentation: 17: 9.21. Aggregate FunctionsLearn how to use aggregate functions to compute a single result from a set of input values. See the syntax, description, and partial mode support for each built-in aggregate function, such as avg, count, json_agg, and more.
Note that these functions must be invoked using window function syntax, i.e., an OVER clause is required. In addition to these functions, any built-in or user-defined ordinary aggregate (i.e., not ordered-set or hypothetical-set aggregates) can be used as a window function; see Section 9.21 for a list of the built
Learn how to use aggregate functions to compute a single result from multiple input rows in PostgreSQL. See examples of count, sum, avg, max, min, and group by with aggregate functions.
Learn how to create and use custom aggregate functions in PostgreSQL, using state values and transition functions. See examples of simple, polymorphic, ordered-set, and partial aggregates, and how to support moving-aggregate mode.
https://docs.postgresql.fr › current › functions-aggregate.html
9.21. Fonctions d'agrégat - PostgreSQLLes fonctions d'agrégat calculent un seul résultat à partir d'un ensemble de valeurs en entrée. Les fonctions d'agrégat natives à but général sont listées dans Tableau 9.59 alors que les agrégats statistiques sont dans Tableau 9.60.
https://docs.postgresql.fr › 12 › functions-aggregate.html
9.20. Fonctions d'agrégat - PostgreSQLLes fonctions d'agrégat calculent une valeur unique à partir d'un ensemble de valeurs en entrée. Les fonctions d'agrégat généralistes fournies par défaut sont listées dans Tableau 9.55 et les agrégats statistiques dans Tableau 9.56.
https://www.postgresql.org › docs › current › tutorial-agg.html
PostgreSQL: Documentation: 17: 2.7. Aggregate FunctionsLearn how to use aggregate functions to compute a single result from multiple input rows in PostgreSQL. See examples of count, sum, avg, max, min, and group by with aggregate functions.
https://www.postgresql.org › docs › current › xaggr.htm
PostgreSQL: Documentation: 17: 36.12. User-Defined AggregatesLearn how to create and use custom aggregate functions in PostgreSQL, using state values and transition functions. See examples of simple, polymorphic, ordered-set, and partial aggregates, and how to support moving-aggregate mode.
https://postgrespro.com › docs › postgresql › 11 › functions-aggregate.html
PostgreSQL : Documentation: 11: 9.20. Aggregate FunctionsAggregate functions compute a single result from a set of input values. The built-in general-purpose aggregate functions are listed in Table 9.52 and statistical aggregates in Table 9.53. The built-in within-group ordered-set aggregate functions are listed in Table 9.54 while the built-in within-group hypothetical-set ones are in Table 9.55.
https://postgrespro.com › docs › postgresql › 13 › functions-aggregate
PostgreSQL : Documentation: 13: 9.21. Aggregate FunctionsLearn how to use aggregate functions to compute a single result from a set of input values in PostgreSQL. See the syntax, description, and examples of general-purpose, statistical, and ordered-set aggregate functions.
https://postgrespro.com › docs › postgresql › 9.4 › functions-aggregate
PostgreSQL : Documentation: 9.4: Aggregate FunctionsLearn how to use aggregate functions to compute a single result from a set of input values in PostgreSQL 9.4. See the list of built-in general-purpose and statistical aggregate functions, their arguments, return types, and descriptions.
https://runebook.dev › fr › docs › postgresql › tutorial-agg
PostgreSQL - Aggregate Functions [fr] - Runebook.devComme la plupart des autres produits de bases de données relationnelles, le PostgreSQL prend en charge les fonctions d'agrégation. Une fonction d'agrégation calcule un résultat unique à partir de plusieurs lignes d'entrée. Par exemple, il existe des agrégats pour calculer les count, sum ...
https://www.postgresqltutorial.com › postgresql-aggregate-functions
PostgreSQL Aggregate FunctionsLearn how to use the PostgreSQL aggregate functions such as AVG(), COUNT(), MIN(), MAX(), and SUM() to perform calculations on a set of rows and return a single row. See examples of using aggregate functions with the GROUP BY clause and the sample database.