/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

1 vote124 views3 answers
Read all columns of a table sql
SQL
0 vote135 views1 answer
Jdbc sql connection string
SQL
0 vote131 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote162 views1 answer
Sql create and grant user access to database
SQL
0 vote131 views1 answer
Sql server order by nulls last
SQL
2 votes181 views1 answer
How to create sql database
SQL
0 vote150 views2 answers
Sql query print strings and int
SQL
0 vote166 views1 answer
Sql select rows between 1000 and 2000
SQL
0 vote131 views1 answer
Exclude last comma separated string mysql
SQL
0 vote156 views2 answers
Sql if empty then
SQL