SELECT top(10) LocationName, companyname, COUNT(LocationName) AS TotalCount FROM Job where CountryId = 108 and LocationName !=' ' and CompanyName != '' GROUP BY companyname ORDER BY TotalCount DESC
locationname companyname count hyderabad IBM 45 Banglooru Satyam 32 like this my previous query SELECT top(5) Locationname, COUNT(Locationname) AS TotalCount FROM Job where CountryId = @cntid and Title !=' ' GROUP BY Locationname ORDER BY TotalCount DESC this query result is locationname count hyderabad 45 Banglooru 32 like this, The first query is not working please helpme. Thank you.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)