/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 vote351 views1 answer
Oracle archivelog usage
SQL
2 votes324 views1 answer
Sqlite show table indexes
SQL
0 vote495 views1 answer
Sql insert exemplo
SQL
24 votes341 views5 answers
Sql server insert into select
SQL
0 vote342 views1 answer
Sqlplus change user
SQL
0 vote373 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote308 views1 answer
How to get last client id sql
SQL
1 vote340 views1 answer
PLS-00225 type
SQL
1 vote333 views1 answer
How to run parallel queries in sql server with entity framework
SQL
13 votes409 views3 answers
Mysqldump structure only
SQL