| Country | Ads Number | |
| Sweden | 5000 | |
| India | 3000 | |
| USA | 2800 | |
| Germany | 2600 |
table Name: ads [AdsID] Primary key ,[UID] ,[Section] ,[Category] ,[Country] ,[State] ,[City] ,[AdsTit] ,[AdsDesc] ,[AdsPrice] ,[Img1] ,[Img2] ,[Img3] ,[Img4] ,[Img5] ,[Wtags] ,[AdsDate] ,[Website] ,[premium]
Abhishek JaiswalPosted Jun 30, 2014, 12:23 AM
query will go like this:
select top 4 Country
from Ads
where(Ads Number>=2600);