DBMS PRESENTATION AGGREGATE FUNCTIONS
2021/2022
NAME: ROHAN PRAKASH K USN: 20BTRCS117
Esto es un párrafo listo para contener creatividad, experiencias e historias geniales.
TABLE OF CONTENT
INTRODUCTION
TYPES OF AGGREGATE FUNCTION
EXAMPLES
CONCLUSION
What is Aggregate Function?
An Aggregate function is a function where the values of multiple rows are grouped together to form a single summary value. They usually take multiple rows from the table and return a value according to the query.
Syntax for Aggregate Function
aggregate_function([DISTINCT|ALL]expression)
TYPES OF AGGREGATE FUNCTION
COUNT FUNCTION
COUNT function is used to Count the number of rows in a database table. It can work on both numeric and non-numeric data types.
Syntax
COUNT(*)
or
COUNT( [ALL|DISTINCT] expression )
sample table
Example: COUNT()
EXAMPLE: COUNT() WITH HAVING
Sum Function
Sum function is used to calculate the sum of all selected columns. It works on numeric fields only.
Syntax
SUM() or SUM( [ALL|DISTINCT] expression )
Avg Function
The AVG function is used to calculate the average value of the numeric type. AVG function returns the average of all non-Null values.
Syntax
AVG()
or
AVG( [ALL|DISTINCT] expression )
Max Function
MAX function is used to find the maximum value of a certain column. This function determines the largest value of all selected values of a column.
Syntax
MAX() or MAX( [ALL|DISTINCT] expression )
Min Function
MIN function is used to find the minimum value of a certain column. This function determines the smallest value of all selected values of a column.
Syntax
MIN()
or
MIN( [ALL|DISTINCT] expression )
Conclusion
Aggregation of Entities in the Database Management System corresponds to a connection between two entities that are theoretically at the same hierarchical level in the ER model. The relationship created between the entities can also be represented in the ER model as ‘has-a,’ ‘is-a’ or ‘is-part-of’ relationships, which can have any type of entities from the Entity-Relationship tree. Aggregation does not characterize any alteration on the flow of navigation through the hierarchical ER model, or the relationship pattern in the ER model.
THANK YOU
Esto es un párrafo listo para contener creatividad, experiencias e historias geniales.
aggregate function
Rohan Prakash K
Created on November 21, 2022
for dbms
Start designing with a free template
Discover more than 1500 professional designs like these:
View
Memories Presentation
View
Pechakucha Presentation
View
Decades Presentation
View
Color and Shapes Presentation
View
Historical Presentation
View
To the Moon Presentation
View
Projection Presentation
Explore all templates
Transcript
DBMS PRESENTATION AGGREGATE FUNCTIONS
2021/2022
NAME: ROHAN PRAKASH K USN: 20BTRCS117
Esto es un párrafo listo para contener creatividad, experiencias e historias geniales.
TABLE OF CONTENT
INTRODUCTION
TYPES OF AGGREGATE FUNCTION
EXAMPLES
CONCLUSION
What is Aggregate Function?
An Aggregate function is a function where the values of multiple rows are grouped together to form a single summary value. They usually take multiple rows from the table and return a value according to the query.
Syntax for Aggregate Function
aggregate_function([DISTINCT|ALL]expression)
TYPES OF AGGREGATE FUNCTION
COUNT FUNCTION
COUNT function is used to Count the number of rows in a database table. It can work on both numeric and non-numeric data types.
Syntax
COUNT(*) or COUNT( [ALL|DISTINCT] expression )
sample table
Example: COUNT()
EXAMPLE: COUNT() WITH HAVING
Sum Function
Sum function is used to calculate the sum of all selected columns. It works on numeric fields only.
Syntax
SUM() or SUM( [ALL|DISTINCT] expression )
Avg Function
The AVG function is used to calculate the average value of the numeric type. AVG function returns the average of all non-Null values.
Syntax
AVG() or AVG( [ALL|DISTINCT] expression )
Max Function
MAX function is used to find the maximum value of a certain column. This function determines the largest value of all selected values of a column.
Syntax
MAX() or MAX( [ALL|DISTINCT] expression )
Min Function
MIN function is used to find the minimum value of a certain column. This function determines the smallest value of all selected values of a column.
Syntax
MIN() or MIN( [ALL|DISTINCT] expression )
Conclusion
Aggregation of Entities in the Database Management System corresponds to a connection between two entities that are theoretically at the same hierarchical level in the ER model. The relationship created between the entities can also be represented in the ER model as ‘has-a,’ ‘is-a’ or ‘is-part-of’ relationships, which can have any type of entities from the Entity-Relationship tree. Aggregation does not characterize any alteration on the flow of navigation through the hierarchical ER model, or the relationship pattern in the ER model.
THANK YOU
Esto es un párrafo listo para contener creatividad, experiencias e historias geniales.