/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

4 votes205 views1 answer
Oracle change nls_date_format permanently
SQL
1 vote162 views1 answer
Liquibase alter column type / length
SQL
0 vote142 views1 answer
Date diff sql
SQL
17 votes172 views2 answers
Mysql date to string
SQL
0 vote143 views1 answer
Test connection to sql server
SQL
3 votes184 views2 answers
How to open postgresql in windows
SQL
0 vote143 views3 answers
Average salary in sql
SQL
0 vote253 views1 answer
Drop check command
SQL
0 vote166 views1 answer
Data types mysql vs postgresql
SQL
3 votes250 views4 answers
Sql interview questions
SQL