>I have a table like:
>Area, Customer,Value
>
>Is there one Sql command which will select the Top 20 Cusotmers, By Value in each Area ?
>Tia
>Gerard
SQL 2005+
;with cte as (select *, row_Number() over (partition by Area order by [Value] DESC) as [Row] FROM CustomersInfo)
select * from cte where Row <=20
If it's not broken, fix it until it is.
My Blog