sql server select top 2 of each group

Solutions on MaxInterview for sql server select top 2 of each group by the best coders in the world

Search
showing results for - "sql server select top 2 of each group"
Alya
29 Mar 2018
1SELECT * FROM 
2(
3SELECT column1, 
4column2,
5cloumn3, 
6row_number() over (PARTITION BY ColumnToGroupBy ORDER BY ColumnToOrderBy DESC) AS TempColumnName
7FROM cities
8) AS TempTableName
9WHERE TempTableName <= 2
10
source
similar questions
join multiple select statements as tablessql left join multiple tables with conditionsselect multiple row from primary key sqlsql select merge multiple valuessql select all from one table and one column from anotherselecting multiple columns in sqlsql select first record of each grouphow to select two columns from table with group by one sql serversql group by and select all columnssql select from multiple tables without joinselect a row include list of array with join two table sqlsql select first and last record of each groupsql select most frequent value in groupsql select column name like from multiple tablessql query multiple tablessql 2 way of select uniquesql query row number group byselect 2 rows in sqlselect count distinct multiple columns sql serverselect query in sql for multiple valuessql get all columns from one table but one from another inner joinsql select from multiple tables with conditions
queries leading to this page
sql select top 1 from each groupsql select top 10 of each groupsql server first select top 1000 then group byselect top 1 of each group sqlsql server select top 1 record from each groupsql query select top 1 from each groupsql server select top 2 of each groupsql select top 1 for each groupselect top 3 from each group sqltop 1 of each group sql serversql select top one of each groupselect top 1 from each group sqlsql server select top 2 of each group