select a.[ID],a.[区域],a.[时间],a.[规模],row_number () over (order by a.规模 desc) Num1 ,b.[时间],b.[规模],row_number () over (order by b.规模 desc) Num2 from table a
left join table b on a.区域=b.区域 where a.时间='2018' and b.时间='2017' order by a.ID asc
select a.[ID],a.[区域],a.[时间],a.[规模],row_number () over (order by a.规模 desc) Num1 ,b.[时间],b.[规模],row_number () over (order by b.规模 desc) Num2 from table a
left join table b on a.区域=b.区域 where a.时间='2018' and b.时间='2017' order by a.ID asc