About: Aggregate function

Facets (new session)
Description
Metadata
Settings
- Rule:
- Inverse Functional Properties:
- "Same As":

About: Aggregate function Goto Sponge NotDistinct Permalink

An Entity of Type : yago:Software106566077, within Data Space : dbpedia.org associated with source document(s)
QRcode icon

http://dbpedia.org/describe/?url=http%3A%2F%2Fdbpedia.org%2Fresource%2FAggregate_function

In database management, an aggregate function or aggregation function is a function where the values of multiple rows are grouped together to form a single summary value. Common aggregate functions include: * Average (i.e., arithmetic mean) * Count * Maximum * Median * Minimum * Mode * Range * Sum Others include: * Nanmean (mean ignoring NaN values, also known as "nil" or "null") * Stddev Aggregate functions occur commonly in numerous programming languages, in spreadsheets, and in relational algebra.

Attributes	Values
rdf:type	yago:WikicatSubroutines yago:Abstraction100002137 yago:Code106355894 yago:CodingSystem106353757 yago:Communication100033020 yago:Writing106359877 yago:WrittenCommunication106349220 disease yago:Routine106582403 yago:Software106566077
rdfs:label	وظيفة كلية (ar) Agregační funkce (cs) Aggregatfunktion (de) Aggregate function (en) Fonction d'agrégation (fr) Funzione di aggregazione (it) Агрегатна функція (uk)
rdfs:comment	Agregační funkce jsou v SQL statistické funkce, pomocí kterých systém řízení báze dat umožňuje seskupit vybrané řádky dotazu (získané příkazem SELECT) a spočítat nad nimi výsledek určité aritmetické nebo statistické funkce. Agregační funkce se v SQL používají s konstrukcí GROUP BY. (cs) في علم الحاسوب، الوظيفة الكلية هي إيجاد قيمة العائد من مجموعة من قيم المدخلات مثل مجموعة، أوقائمة. الوظيفة الكلية الشائعة وتشمل: • المتوسط الحسابي • عملية العد • الحد الأقصى • الحد الأدنى • المجموع الوظيفة الكلية شائعة في العديد من لغات البرمجة مثل روبي Ruby، spreadsheets، relational algebra. (ar) Eine Aggregatfunktion ist eine Funktion, die gewisse Eigenschaften von Daten zusammenfasst. (de) En traitement des bases de données, une fonction d’agrégation est un opérateur permettant de réduire des groupes de lignes à une valeur calculée à partir de l’une des colonnes en jeu. Les fonctions les plus simples sont le décompte de lignes, la somme, la moyenne, le maximum et le minimum des valeurs. En SQL, ces fonctions se notent COUNT, SUM, AVG, MAX, MIN. On peut aussi trouver d’autres fonctions comme la concaténation de chaines. * Portail de la programmation informatique * Portail des bases de données (fr) В інформатиці, агрегатна функція (дослівно - функція складеного значення) — функція, яка повертає одинарне значення з колекції вхідних значень такої як множина (set), мультимножина (multiset) або список (list). Серед найпоширеніших агрегатних функцій: * Average * Count * Maximum * Median * Minimum * Mode * Sum Агрегатні функції широко вживані в багатьох мовах програмування, наприклад, Ruby, в електронних таблицях, в реляційній алгебрі. (uk) In database management, an aggregate function or aggregation function is a function where the values of multiple rows are grouped together to form a single summary value. Common aggregate functions include: * Average (i.e., arithmetic mean) * Count * Maximum * Median * Minimum * Mode * Range * Sum Others include: * Nanmean (mean ignoring NaN values, also known as "nil" or "null") * Stddev Aggregate functions occur commonly in numerous programming languages, in spreadsheets, and in relational algebra. (en)
dcterms:subject	Subroutines
Wikipage page ID	6314748 (xsd:integer)
Wikipage revision ID	1068555023 (xsd:integer)
Link from a Wikipage to another Wikipage	Cambridge University Press Relational algebra Standard deviation Maximum Median Online analytical processing Bottleneck (software) Mode (statistics) Contingency table Arithmetic mean Function (computer programming) Parallel computing Pivot table Spreadsheet MapReduce Utility functions on indivisible goods Subroutines Data drilling Data mining Data processing Distributed computing AggregateIQ Fold (higher-order function) OLAP cube Range (statistics) Counting Association for Computing Machinery Summation Monoid homomorphism Divide and conquer algorithm Average Group by (SQL) Minimum Extract, transform, load Computer language Multiset (abstract data type) Summary statistics XML for Analysis SQL:2016 List (computing) Database management Set (computer science) Cross-tabulation
Link from a Wikipage to an external page	https://oracletutorial.net/aggregate-functions.html https://msdn.microsoft.com/en-IN/library/ms173454.aspx https://archive.org/details/aggregationfunct0000unse https://hal.archives-ouvertes.fr/hal-01533675/ https://www.microsoft.com/en-us/research/publication/distributed-aggregation-for-data-parallel-computing-interfaces-and-implementations/
sameAs	Aggregate function Aggregate function Aggregate function Aggregate function Aggregate function Aggregate function Aggregate function Aggregate function Aggregate function Aggregate function Aggregate function
dbp:wikiPageUsesTemplate	dbt:Cite_techreport dbt:Circular_reference dbt:Cite_arXiv dbt:Cite_book dbt:Cite_conference dbt:Mvar dbt:Refbegin dbt:Refend dbt:Reflist dbt:Sfn dbt:Short_description dbt:Tmath
has abstract	Agregační funkce jsou v SQL statistické funkce, pomocí kterých systém řízení báze dat umožňuje seskupit vybrané řádky dotazu (získané příkazem SELECT) a spočítat nad nimi výsledek určité aritmetické nebo statistické funkce. Agregační funkce se v SQL používají s konstrukcí GROUP BY. (cs) في علم الحاسوب، الوظيفة الكلية هي إيجاد قيمة العائد من مجموعة من قيم المدخلات مثل مجموعة، أوقائمة. الوظيفة الكلية الشائعة وتشمل: • المتوسط الحسابي • عملية العد • الحد الأقصى • الحد الأدنى • المجموع الوظيفة الكلية شائعة في العديد من لغات البرمجة مثل روبي Ruby، spreadsheets، relational algebra. (ar) In database management, an aggregate function or aggregation function is a function where the values of multiple rows are grouped together to form a single summary value. Common aggregate functions include: * Average (i.e., arithmetic mean) * Count * Maximum * Median * Minimum * Mode * Range * Sum Others include: * Nanmean (mean ignoring NaN values, also known as "nil" or "null") * Stddev Formally, an aggregate function takes as input a set, a multiset (bag), or a list from some input domain I and outputs an element of an output domain O. The input and output domains may be the same, such as for SUM, or may be different, such as for COUNT. Aggregate functions occur commonly in numerous programming languages, in spreadsheets, and in relational algebra. The listagg function, as defined in the SQL:2016 standardaggregates data from multiple rows into a single concatenated string. (en)

Faceted Search & Find service v1.17_git139 as of Feb 29 2024

Alternative Linked Data Documents: ODE Content Formats:

RDF

ODATA

Microdata

About

OpenLink Virtuoso version 08.03.3330 as of Mar 19 2024, on Linux (x86_64-generic-linux-glibc212), Single-Server Edition (61 GB total memory, 51 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software