/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 votes280 views2 answers
Postgresql search all tables for column name
SQL
0 vote279 views1 answer
Mysql DDL
SQL
0 vote313 views1 answer
Find and replace query in wordpress\
SQL
0 vote258 views1 answer
Sql server update top n records
SQL
0 vote284 views4 answers
User defined function sql
SQL
0 vote281 views1 answer
Check connections to database postgres
SQL
0 vote283 views1 answer
Sql get number of days between two dates
SQL
4 votes271 views2 answers
REST API
SQL
0 vote285 views1 answer
Database xml sql
SQL
0 vote259 views1 answer
Mysql workbench not showing schemas
SQL