Hi
1- i have a table called ads and there is country column, and i want to get the newst countiers names which has new records in the table.
2- and i want to get the top 5 of the countries has records amounts in the database.
table Name: ads
[AdsID] Primary key
,[UID]
,[Section]
,[Category]
,[Country]
,[State]
,[City]
,[AdsTit]
,[AdsDesc]
,[AdsPrice]
,[Img1]
,[Img2]
,[Img3]
,[Img4]
,[Img5]
,[Wtags]
,[AdsDate]
,[Website]
,[premium]
Go to the complete details ...