10 -1 | Window Function in SQL | Aggregate Window Function in SQL | SUM() OVER(), AVG() OVER()

A window function in SQL Server is a tool for performing calculations across a specific set of rows related to the current row within the result set of a query. It enables analytical and statistical operations, allowing computation within query results.

TYPES:
Aggregate Window Functions
SUM(), COUNT(), MIN(), MAX(), AVG().
Ranking Window Functions
ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE().
Value/Analytic Window Functions
LEAD(), LAG(), FIRST_VALUE(), LAST_VALUE().

SYNTAX:
SELECT column-name(s)
, FUNCTION() OVER( [PARTITION BY Clause]
[ORDER BY Clause]
[ROWS OR RANGE Clause]
) AS name
FROM table-name

Subscribing to my channel is more than just a click—it's an invitation to join a community of learners and enthusiasts. With each video, we embark on a journey together, exploring new ideas, honing skills, and finding inspiration. So hit that subscribe button, and let's embark on this exciting adventure of discovery and growth, together.

#windowfunction #aggregatewindowfunction #sql #sqlserver #sqlservertutorial #sqlservermanagementstudio #rdbms
#codinginnepalilanguage.