oracle容易的分析函数用法

分类: IT文章 • 2022-09-01 14:42:56

oracle简单的分析函数用法
select url,state,operdate,iplocation,
       row_number() OVER(PARTITION BY url ORDER BY operdate desc) row_num
       from blacklist
       where state in (1,3)