/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

2 votes219 views1 answer
Dbms transaction (psql)
SQL
23 votes193 views3 answers
Mysqldump
SQL
2 votes205 views1 answer
Q operator in sql
SQL
1 vote204 views2 answers
Drop function in sql
SQL
10 votes205 views2 answers
Rtrim sql
SQL
5 votes203 views1 answer
Minecraft java port number
SQL
0 vote195 views1 answer
Connect postgresql using a connection string
SQL
0 vote210 views1 answer
Why we have to set the password for my sql server
SQL
0 vote211 views1 answer
Postgres create extension if not exists
SQL
0 vote198 views1 answer
Sql delimiter to columns
SQL