Horje
sql server select top 2 of each group Code Example
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: www.silota.com



Sql

Related
sql rename column Code Example sql rename column Code Example
database dump mysql command Code Example database dump mysql command Code Example
mysql trim whitespace Code Example mysql trim whitespace Code Example
mysql slave status Code Example mysql slave status Code Example
t sql get foreign key Code Example t sql get foreign key Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje