Glossary: SQL Beyond the Basics

RANK / DENSE_RANK / ROW_NUMBER

Also written: RANK, DENSE_RANK, ROW_NUMBER, ranking

Window functions that number rows in order and differ on ties. ROW_NUMBER gives 1, 2, 3, 4; RANK gives 1, 2, 2, 4; DENSE_RANK gives 1, 2, 2, 3.