Window functions provide the ability to perform calculations across sets of rows that are related to the current query row. See