/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

8 votes113 views1 answer
Sql remove characters from string right
SQL
1 vote123 views4 answers
Psql check tables command
SQL
0 vote131 views1 answer
Sql search all columns of database oracle sql
SQL
0 vote178 views1 answer
Oracle temporary table
SQL
4 votes119 views3 answers
Create database in mySQL
SQL
10 votes140 views4 answers
Join multiple tables in sql
SQL
0 vote131 views1 answer
Date on SQL
SQL
0 vote125 views1 answer
Sql get user account
SQL
1 vote113 views1 answer
Sql alchemy with azuresql server
SQL
0 vote121 views1 answer
Sql convert datetime to year
SQL