SQL 18: Window Function in SQL (Aggregate and Non Aggregate) || Rank, Dense rank, Row Number

SQL has window function which helps us to find the data based on ranks or Row Number by using Over clause and Partition by Clause with Following Window Functions

1. Aggregate Window Functions
SUM
COUNT
MIN
MAX
AVG
2. Non-Aggregate Window Functions
Row number
Rank
Dense Rank