Window sort functions provide the sorting data information, such as row number and rank, within specific groups as part of the data returned. The most commonly used sort functions are as follows:
- row_number: Assigns a unique sequence number starting from 1 to each row, according to the partition and order specification.
- rank: Ranks items in a group, such as finding the top N rows for specific conditions.
- dense_rank: Similar to rank, but leaves no gaps in the ranking sequence when there are ties. For example, if we rank a match using dense_rank and have two players tied for second place, we would see that the two players were both in second place and that the next person is ranked third. However, the rank function would ...