oracle容易的分析函数用法

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)