SELECT * FROM ( SELECT column1, column2, cloumn3, row_number() over (PARTITION BY ColumnToGroupBy ORDER BY ColumnToOrderBy DESC) AS TempColumnName FROM cities ) AS TempTableName WHERE TempTableName <= 2