+-----------+----------------------+-----------------------+-----------------------+
| review_id | old_group | new_group | desired_result |
+-----------+----------------------+-----------------------+-----------------------+
| 1 | null | null | BATCH |
| 2 | null | null | BATCH |
| 3 | BATCH | LEVEL_1 | LEVEL_1 |
| 4 | null | null | LEVEL_1 |
| 5 | LEVEL_1 | LEVEL_2 | LEVEL_2 |
| 6 | LEVEL_2 | L3 | LEVEL_3 |
| 7 | null | null | LEVEL_3 |
| 8 | null | null | LEVEL_3 |
| 9 | null | null | LEVEL_3 |
+-----------+----------------------+-----------------------+-----------------------+
我在snowflake中工作,需要写一个SQL查询,基于一个new_group和old_group将创建一个新的列填补空白 每个评审都分配了一个新的和旧的组,我需要组合这些值,以便有一个单独的列,显示该评审的特定评审组.
我试过 FIRST_value(new_group忽略空)OVER(Order BY review_id ROWS between current Row and unbounded folLOWING)但是,它没有提供正确的结果:最后的 comments 是空的,因为没有即将到来的组,并且 comments 有点偏移.