I am using MS SQL Server r 8
I have created a query to pull information regarding my providers as follows:
From [dbo].[ProviderDim] PD
Join [dbo].[ProviderLobRegionXref] PR
Join [dbo].[MarketLevelDim] MD
Where PD.Active ='1'
And MD.OperationalMarket <>'TERMED'
Order by MD.OperationalMarket, PL.LanguageDesc,PD.ProviderId
The resulting data gives me a list of all providers by Region and Operational Market and the languages each provider speaks. I need to show for Each Region there are 8, the top 4 common languages spoken for each region I already know that English will be number 1, but then I need to show Number 2 is there another language that Ranks as 2nd and 3rd and 4th? How can I do this. I am not advanced in SQL so I may need more direction than others. Thank you in advance for any help.
- Proposed as answer by Mike YinMicrosoft contingent staff, Moderator Tuesday, September 10, 2013 1:19 AM