select nvl2(score1,row_number() over(order by score1 desc nulls last )||'/'||count(score1)over(),'-'), nvl2(score2,row_number() over( order by score2 desc nulls last )||'/'||count(score2)over(),'-'), nvl2(score3,row_number() over( order by score3 desc nulls last )||'/'||count(score3)over(),'-'), name from testa
你的表有3个字段,可以插入 4个 值,这也行?
另外 表述不清楚
nvl2(score1,row_number() over(order by score1 desc nulls last )||'/'||count(score1)over(),'-'),
nvl2(score2,row_number() over( order by score2 desc nulls last )||'/'||count(score2)over(),'-'),
nvl2(score3,row_number() over( order by score3 desc nulls last )||'/'||count(score3)over(),'-'),
name
from testa