/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

0 vote272 views1 answer
Regex mongoose
SQL
24 votes197 views6 answers
Rename a column in sql server
SQL
0 vote197 views1 answer
Mysql in clausule string array
SQL
7 votes195 views1 answer
Sql management studio display line numbers
SQL
1 vote208 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
5 votes223 views1 answer
Oracle list functions
SQL
0 vote206 views1 answer
Declare or use variable in snowflake
SQL
0 vote211 views1 answer
Power bi dax add related shows column but not working
SQL
8 votes282 views1 answer
Oracle search code in packages
SQL
0 vote194 views1 answer
Mysql update sum same table
SQL