/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

6 votes150 views2 answers
Where clause in sql
SQL
0 vote156 views1 answer
Sql out file formate
SQL
0 vote184 views2 answers
How to take recent row without limit in mysql
SQL
0 vote162 views1 answer
Drop all data from tables
SQL
11 votes139 views1 answer
Ddl materialized view
SQL
0 vote141 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
1 vote156 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote96 views1 answer
Get all stored procedures in sql server
SQL
3 votes90 views1 answer
How to get list of synonyms in oracle
SQL
0 vote131 views1 answer
Check sql database table lock
SQL