Window Functions
1 post1 project
- Handling Duplicate Data in Azure Data FlowsEliminating duplicate rows and retaining latest records using Aggregate and Window transformations in Data Flow.Post
- Danny's Diner SQL Case StudyAnalyzed customer behavior and sales for a Japanese diner using PostgreSQL. Tackled real-world questions with CTEs and subqueries. Revealed purchase patterns and visit frequency.Project
Often used with