Window Functions in SQL

Windowing functions are a powerful tool that helps to leverage the power of SQL for Data Analysis.

Windowing functions can simply be thought of as using an aggregate but instead of getting one output for all the table like sum, average, min, max, or count we would like to broadcast the value obtained to all of the output table or a specific window we would ideally indicate the window size by “PARTITION by”.