select evalutor,
max(case when seq = 1 then evalutee end) as evalutee1,
max(case when seq = 2 then evalutee end) as evalutee2,
max(case when seq = 3 then evalutee end) as evalutee3
from (select t.*, row_number() over (partition by evalutor order by evalutee) as seq
from table t
) t
group by evalutor;
1条答案
按热度按时间ia2d9nvy1#
因为您有sql server标记,所以我将使用
row_number()
具有条件聚合的函数: