/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

50 votes236 views6 answers
Sql count duplicate rows
SQL
3 votes130 views1 answer
Oracle wait
SQL
22 votes172 views4 answers
Mysql format date
SQL
1 vote139 views2 answers
Mysql update LAST_INSERT_ID()
SQL
0 vote138 views1 answer
Update and keep original value sql
SQL
9 votes130 views3 answers
Where in sql
SQL
0 vote142 views1 answer
Show tables in cassandra cql
SQL
-1 vote130 views1 answer
How to switch user in mysql
SQL
0 vote139 views1 answer
Describe in sqlite3
SQL
0 vote139 views1 answer
Trigger value from maltiple table to single table mysql
SQL