select t1.info_id,t1.info_type,t1.create_city from (
select row_number() over(partition by create_city order by t2.create_date desc) rn, t2.*
from T_LABOURUNION_INFO t2
where t2.info_type = '500200'
and t2.create_city in ('商洛',
'省公司',
'西安',
'榆林',
'安康',
'咸阳',
'宝鸡',
'渭南',
'延安',
'铜川',
'汉中')
) t1 where t1.rn =1