/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

2 votes319 views1 answer
Metasploit start postgresql
SQL
4 votes301 views4 answers
Oracle tablespace tables list
SQL
-1 vote307 views1 answer
Can pandas fetch data from sql
SQL
0 vote297 views1 answer
Oserror mysql_config not found virtualenv
SQL
1 vote304 views1 answer
Mysql drop key
SQL
8 votes303 views5 answers
Grant permission in postgres
SQL
0 vote277 views1 answer
Oracle select invalid views
SQL
1 vote276 views1 answer
Clear screen command in psql
SQL
0 vote356 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
-1 vote292 views1 answer
Mysql delete duplicate rows except one
SQL