Types of SQL Window Functions. There are a lot of window functions that exist in SQL but they are primarily categorized into 3 different types: Aggregate window functions; ...