我的一段存储过程想用partition by来实现,我可以使用row_number(),但是如果使用FIRST_VALUE(),RANK()等函数,系统就提示没有权限, 错误信息如下:
SQL0440N No authorized routine named "RANK" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42884。
我的测试代码如下:
with a as (select 1 a from sysibm.dual
union all
select 1 a from sysibm.dual
union all
select 1 a from sysibm.dual
union all
select 2 a from sysibm.dual
union all
select 3 a from sysibm.dual
union all
select 4 a from sysibm.dual
union all
select 4 a from sysibm.dual
union all
select 5 a from sysibm.dual
)
select a, rank(a)over(partition by a) b from a
order by a;
请问这是要怎么解决
收起