---
title: "Discussion on \"SQL Window Functions - Basics\" | Hashnode"
description: "Discussion on \"SQL Window Functions - Basics\". 1. OVER()\nApplies a function over all rows if not partitioned.\nSELECT name, salary, \n       AVG(salary) OVER() AS avg_salary \nFROM employees;\n\n\nCalculates the overall average salary for every row.\n\n2. PARTITION BY\nDivides result into groups (like GRO..."
url: "https://hashnode.com/posts/sql-window-functions-basics/687506048024d328b4217e49"
---

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

Discussion

# [SQL Window Functions - Basics](https://abheeshta-techdumps.hashnode.dev/sql-window-functions-basics?utm_source=hashnode&utm_medium=feed)

1\. OVER() Applies a function over all rows if not partitioned. SELECT name, salary, AVG(salary) OVER() AS avg\_salary FROM employees; Calculates the overall average salary for every row. 2. PARTITION BY Divides result into groups (like GRO...

Jul 14, 2025 · 2 min read · abheeshta-techdumps.hashnode.dev  
Read the article

-   [#sql](https://hashnode.com/tag/sql)
-   [#sql-window-functions](https://hashnode.com/tag/sql-window-functions)
-   [#windowfunction](https://hashnode.com/tag/windowfunction)
-   [#mysql](https://hashnode.com/tag/mysql)

## Written by

[Abheeshta P](https://hashnode.com/@abheeshta)

@abheeshta · Manglore,Karnataka

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

Living Between Pixels and Logic – My Digital Journal.

I’m a Full-stack Developer who enjoys turning ideas into simple and useful experiences. I like building clean user interfaces, exploring AI, and understanding how things work behind the scenes. From creating websites to trying out new technologies, I’m always curious and learning something new. Next.js, Node.js, MongoDB, and Java Spring Boot are the tools I use regularly. I enjoy experimenting with projects, sharing what I learn, and improving with every build. Vibing + Thinking.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
