SAMPLE RECORDS
sampledata_top10

Query for getting top 10 records based on the company values with duplicate values


select T.Country 'Text', T.Company'Value'
from (
       select Country , Company,
              dense_rank() over(order by Companydesc) as rn
       from TableName      
     ) T
where T.rn <= 10

Advertisements