Group By vs Window Functions - Big Difference
There is one big difference between Group By & Window Function.
The Group BY output may have less than or equal number of records than the input rows.
While WINDOW function does not reduce the input rows.
![SQL Timestamp ETL timezone problems are a NIGHTMARE [ETL Scenario -4] #sql #etl](https://images.videosashka.com/watch/7OQGTmU-SHs)
![Aggregate Fact Tables in Data Warehouse - Concept you must know [ETL Scenario -5] #etl #sql #dwh](https://images.videosashka.com/watch/Sy4_pkUqGmE)
![ETL Script Types and Concepts: The Ultimate Guide [ETL Scenario -3] #etl #sql](https://images.videosashka.com/watch/Xol-A26o6MQ)
![Intra-day Job orchestration & SQL: A full tutorial with example [ETL Scenario -2] #etl](https://images.videosashka.com/watch/kbQceQLRRZI)
![Do NOT run DROP TABLE in PRODUCTION. Use 2 alternate solutions [ETL Scenario -1 ] #etl #sql](https://images.videosashka.com/watch/FrlhAScErV8)
![The Frightening Reality Of Missing Records In An ETL Scenario [ETL Scenario -6] #sql #etl](https://images.videosashka.com/watch/w6SRJI0KZ6Q)
