sql statment for getting top 5

Question

I have a table called ads and I want to get top 5 countries that ads comes from, and the most popular section in each of those 5 countries counties. for example: India is top 1 and the user from India has chose properties section, Sweden is top 2 and Swedish popular section is Cars,...
In other way I want to get the top 5 countries that ads comes from in my database and I want to get the most section selected by each country, hope that will be more clear :-)

table Name: ads [AdsID] Primary key ,[UID] ,[Section] ,[Category] ,[Country] ,[State] ,[City] ,[AdsTit] ,[AdsDesc] ,[AdsPrice] ,[Img1] ,[Img2] ,[Img3] ,[Img4] ,[Img5] ,[Wtags] ,[AdsDate] ,[Website] ,[premium]

Mike Simo · Answer

@ Abhay Shanker thanks for reply the columns are Country and Section. in country i have more than 30 countries so i want to get the top 5 countries in ads table which has biggest numbers of ads in the table and also show the most used section in each of those top 5 countries for example: 1- Country: India. top 3 section used in India : Cars properties Electronics. 1- Country: USA. top 3 section used in USA: Furniture properties Animals. And so on i hope that is more clear :-)

Abhay Shanker · Answer

could you please explain the field or column on the basis of which you want to write script. It will be also helpful if you can share the details with some sample information