Question

求一条sql语句，把图一转换成图二。

Answer 1

select cpname
,max(decode(rvl,1,PEJIAN) )as PEJIAN1
,max(decode(rvl,2,PEJIAN) )as PEJIAN2
,max(decode(rvl,3,PEJIAN) )as PEJIAN3
,max(decode(rvl,4,PEJIAN) )as PEJIAN4
from
(
select cpname,PEJIAN,id
,rank() over(partition by cpname order by id) as rvl

from test_a
)
group by cpname
--将扮渗哗test_a换喊返成你的厅行table就可以了

追问

select cpname,PEJIAN,id
,rank() over(partition by cpname order by id) as rvl
这句出错！

Answer 2

後面3列（peijian1，peijian2，peijian3）数据分类逻辑？