Tag feed

#analytical-function

2 posts2 followers

Learning SQL Window Functions - The Right Way

Nov 6, 2023 · 8 min read · 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...

Join discussion

PGPratima Gautamgautampratima.com.np

0

Window Functions in SQL

Apr 27, 2023 · 3 min read · In SQL, computations over a collection of rows that are connected to the current row are performed using Windows functions (also known as analytical functions). Running totals, moving averages, and other aggregate values within a set of data can be d...

Join discussion

#analytical-function

Search Hashnode

#analytical-function

Learning SQL Window Functions - The Right Way

Window Functions in SQL