SELECT top(16) LocationName, COUNT(LocationName) AS TotalCount FROM Job where CountryId = 108 GROUP BY LocationName ORDER BY TotalCount DESC
1 Banglore 900 2 hyderabad 850 3 vijawada 800 4 200 5 karnataka 100
SELECT top(16) LocationName, COUNT(LocationName) AS TotalCount FROM Job where CountryId = 108 and Location IS NOT NULL GROUP BY LocationName ORDER BY TotalCount DESC
SELECT top(5) Title, COUNT(Title) AS TotalCount FROM Job where CountryId = @cntid and Title !=' ' GROUP BY Title ORDER BY TotalCount DESC
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)