---
title: "Discussion on \"Learning SQL Window Functions - The Right Way\" | Hashnode"
description: "Discussion on \"Learning SQL Window Functions - The Right Way\". Why Window Functions?\nThere is no simple way in SQL to calculate running aggregate on data e.g. for a monthly sales data, we may need to calculate the cumulative sales.\n\nLet's take a simple table of sales data. How will I get -\n\nExample#1 - Monthly c..."
url: "https://hashnode.com/posts/learning-sql-window-functions-the-right-way/65490c76732aeb1a504d688e"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Learning SQL Window Functions - The Right Way](https://roshan-jha.hashnode.dev/learning-sql-window-functions-the-right-way?utm_source=hashnode&utm_medium=feed)

Why Window Functions? There is no simple way in SQL to calculate running aggregate on data e.g. for a monthly sales data, we may need to calculate the cumulative sales. Let's take a simple table of sales data. How will I get - Example#1 - Monthly c...

Nov 6, 2023 · 8 min read · roshan-jha.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#window-function](https://hashnode.com/tag/window-function)
-   [#analytical-function](https://hashnode.com/tag/analytical-function)
-   [#rank-dense-rank](https://hashnode.com/tag/rank-dense-rank)

## Written by

[Roshan Jha](https://hashnode.com/@jha01roshan)

@jha01roshan · Noida, India

  
[View profile](https://hashnode.com/@jha01roshan)

AI, ML Advocate | Data Engineering for Living

Past - Co-founder and Chief-Instructor at 10xAI Learning. Current - Technical Consultant @TechMahindra I am a passionate learner and learn every day. Take immense pleasure in sharing and imparting the knowledge to others. roshan@10xai.co, +91-9910-680-420

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
