oracle行转列
以下是我曾经写的一个例子:with tmp_tab as(select p.patient_id,i.patient_name,TRUNC(i.plan_time) as ,i.vitalsign_nval1 || '/' || i.vitalsign_nval2 as xy, row_number() OVER(PARTITION BY p.patient_id, TRUNC(i.plan_time) ORDER BY TRUNC(i.plan_time) desc) as row
原创
2021-07-30 09:33:51 ·
155 阅读 ·
0 评论