Please enable JavaScript.
Coggle requires JavaScript to display documents.
Advanced SQL Concepts - Coggle Diagram
Advanced SQL Concepts
-
SQL function types
- Scalar functions: Take a single function and return a single value (CONCAT, UPPER, LOWER)
- Aggregate functions: Take a set of values and return a single value (MAX, MIN, AVG)
- Window functions: These functions are executed over a set of rows (a window of values) and the values are calculated in a row context accessing the previous or following rows for calculation (RANK)
-
-
-