Group Functions in SQL | Oracle SQL fundamentals

Published: 26 December 2018
on channel: DBA Genesis
879
7

Group functions are mathematical #functions to operate on sets of #rows to give one result per set. The types of group functions (also called aggregate functions) are: #AVG, that calculates the average of the specified #columns in a set of rows, #COUNT, calculating the number of rows in a set.

00:00 SQL Functions
01:05 Definition of Single Row Function
01:18 Example of Single Row Function
02:29 What is Multiple Row Function?
03:31 Example of Multiple Row Function
04:26 What are Multiple Row Function?

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis