sql縱錶轉換成橫表，sql縱表

sql縱錶轉換成橫表，sql縱表

資料庫中 將一張縱錶轉換為一張橫表

資料庫縱表資料

sql語句如下

select cardid,max(case t.projectcode when 'IA-002' then t.result  end) as ht,max(case t.projectcode when 'IA-003' then t.result end) as wt,max(case t.projectcode when 'IA-005' then t.result  end) as bmi,max(case t.projectcode when 'IA-000' then t.result  end) as xl,max(case t.projectcode when 'CG-005' then t.result end) as xybhd,max(case t.projectcode when 'CD-002' then t.result  end) as kfxt,max(case t.projectcode when 'CD-003' then t.result  end) as chxt,max(case t.projectcode when 'IA-014' then t.result end) as xy,max(case t.projectcode when 'JA-001' then t.result  end) as xd,datetime from projectresultinfo t group by t.cardid  order by datetime desc