/SQL/Sql server select top 2 of each group

Sql server select top 2 of each group

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

Source: silota.com

Similar codes

1 vote201 views1 answer
Host 127.0 0.1 is not allowed to connect to this mysql server
SQL
0 vote206 views2 answers
Oracle chain rules
SQL
0 vote189 views1 answer
Postgresql get current user name
SQL
5 votes240 views1 answer
How to check port number for postgresql
SQL
0 vote234 views1 answer
How to open mysql in docker
SQL
0 vote256 views1 answer
Postgres - Login and connect as default user
SQL
0 vote230 views1 answer
Mysql where sum > 0
SQL
3 votes197 views2 answers
Mysql HAVING
SQL
0 vote231 views1 answer
Sql tablo hangi sp de
SQL
8 votes201 views2 answers
Safe update mode in mysql
SQL