我的第一个查询如下所示：

select trans.* from
  ( select 
   acc_num,
   acc_type,
   trans_amount,
   load_date,
   rank() over(partition by acc_num order by load_date) as rk
   from monetary
   where rat_code = 123
 ) trans

where trans.rk =1;

第二个查询如下所示

with a as (
select *, 
row_number() over(partition by acc_num order by load_date) as rn
from monetary
where rat_code = 123 )
select 
acc_num,
acc_type,
trans_amount,
load_date
from a
where rn =1;

任何人都可以请帮助我，我得到不同数量的记录为两个案件。虽然查询是相同的。