我有一个类似于下表的表格:
Name | Current submission | Submission | Date |
---|---|---|---|
A | 43-01 | 43-01 | 1-1-2019 |
A | 43-01 | 42-01 | 1-1-2020 |
A | 43-01 | 42-02 | 1-1-2021 |
A | 43-01 | 42-03 | 1-1-2022 |
我希望它看起来如下所示:
Name | Current submission | Submission | Date |
---|---|---|---|
A | 42-03 | 43-01 | 1-1-2019 |
A | 42-03 | 42-01 | 1-1-2020 |
A | 42-03 | 42-02 | 1-1-2021 |
A | 42-03 | 42-03 | 1-1-2022 |
下面是我用来获取第一个表的代码:
SELECT
Submission,
MAX(Submission) over (partition by Name) as [Current Submission],
Date
FROM Table_Name
我试着用MAX(Date)
做CASE WHEN
个陈述,但我不能正确地理解逻辑……