/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 vote228 views1 answer
Sql server on mac m1
SQL
0 vote239 views1 answer
Sql output select
SQL
0 vote238 views3 answers
Classement rang mysql 7
SQL
1 vote224 views3 answers
How to update column name in psql
SQL
-2 votes257 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote177 views1 answer
Denied
SQL
1 vote223 views1 answer
Mysql return text after a final full stop
SQL
5 votes239 views1 answer
Invalid column name sql
SQL
2 votes240 views2 answers
Maximum execution time of 360 seconds exceeded
SQL
0 vote237 views1 answer
Sqlcl format
SQL