What are window functions?
Window functions compute values across a related set of rows without collapsing them into one row per group.
- Use OVER clause
- Great for ranking and running totals
- Keeps detail rows
What are window functions?
Tagged with analytics
2 cards
What is a data warehouse?
A data warehouse is a system optimized for analytical queries over integrated, historical business data.
- Read-heavy analytics store
- Often columnar
- Different goals from OLTP databases
What is a data warehouse?