sql statment for getting top 5

Mike Simo

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]

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mike Simo12y ago
@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 :-)
0
Abhay Shanker12y ago
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
0