Group Functions in SQL | Oracle SQL fundamentals

preview_player
Показать описание
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?

Рекомендации по теме
visit shbcf.ru