/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 vote165 views1 answer
Jooq finding lastest value in table
SQL
0 vote178 views4 answers
Mysql count table rows
SQL
4 votes174 views3 answers
Mysql update with join
SQL
0 vote179 views1 answer
Date datatype in livesql
SQL
1 vote200 views1 answer
Sql set auto increment back to 0
SQL
0 vote179 views2 answers
Default constraint in ms sql
SQL
0 vote182 views1 answer
Subquery aggregation
SQL
11 votes184 views1 answer
Get ddl materialized view oracle
SQL
0 vote234 views3 answers
Call to undefined function mysql_connect()
SQL
1 vote188 views1 answer
Md5 encryption for existing records
SQL