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(5) Title, COUNT(Title) AS TotalCount FROM Job where CountryId = @cntid and Title !=' ' GROUP BY Title ORDER BY TotalCount DESC
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
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)