Mike Simo

Mike Simo

  • NA
  • 17
  • 12.5k

sql statement for top 4

Jun 29 2014 6:53 PM
I have a table called ads and I want to get top 4 countries that has the biggest number of ads >= 2600 in the table, for example:


CountryAds Number
Sweden5000
India3000
USA2800
Germany2600




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

Answers (1)