Question

sql下将同一ID的属性归到同一行

如图，将一个ID的属性都归到同一行，只考虑每个ID都是两个属性的情况即可





Answer 1

select shit.* from
(select ROW_NUMBER() OVER(PARTITION BY a.ID ORDER BY a.属性) as 序号,a.ID,a.属性 as '属性1',b.属性 as '属性2' from 表1 a,表1 b) shit
where shit.序号=1