蜂巢中的等级高于划分

Question

表A中有如下所示的数据:3列属性id、结束日期和键，必须为属性id和结束日期的每个唯一组合填充键字段，如下所示

key property id end date
1   7050    12/31/9999
2   7530    12/31/9999
2   7530    12/31/9999
2   7530    12/31/9999
2   7530    12/31/9999
3   7541    12/31/9999
3   7541    12/31/9999
3   7541    12/31/9999
4   7567    12/31/9999
4   7567    12/31/9999

我试过

select rank() over (partition by property_id,effective_end_date) as key,
       property_id,
       end_date 
 from table A

但是它把1作为所有记录的键。请帮帮忙

Answer 1

使用下面的命令，使用order by：

select rank() over (ORDER by property_id,effective_end_date) as key,
   property_id,
   effective_end_date from table A

Answer 2

它的工作方式是将顺序按添加，如下所示：

select rank() over (partition by property_id order by effective_end_date) as key,
       property_id,
       end_date 
 from table A