RANK()
Rank of each row in a partition
Result type
BIGINT
Syntax
RANK () OVER <window_name_or_spec>
Rows with the same values of window-order get the same rank with in the partition window-partition, if specified.The rank of a row is equal to the number of rank values in the partition preceding the current row, plus one.