Database Aggregate Functions

Опубликовано: 24 Октябрь 2024
на канале: Cody Henrichsen
82
1

Overview of the Aggregate functions for Oracle SQL including use of the GROUP BY and HAVING clauses for coalescing results and filtering results.

Table of Contents:

00:00 - Aggregate Functions
00:07 - Definition
01:18 - Which functions?
01:34 - How?
02:16 - Extra Clauses
03:25 - When?
04:03 - Execution order
04:38 - Execution order of a query
05:08 - Demo Query
05:20 - Limit query with DISTINCT
05:34 - Use Aggregate Function