SELECT distinct city.name, jp.id , ROW_NUMBER() OVER (order by city.name) [sr_no] , COUNT(jp.id) OVER (partition by name) as no_of_posts , COUNT(od.id) OVER (partition by name) as no_of_employers , CONVERT(varchar(12), jp.posting_date, 103) [date_created] FROM rs_job_posting jp INNER JOIN rs_job_posting_location jpl on jp.id = jpl.id INNER JOIN rs_cor_city city on jpl.city_fk = city.id INNER JOIN rs_organization_detail od on od.id = jp.id order by city.name ASC where cast(city.name as int) <= 1
DISTINCT
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)