ROW_NUMBER()
782594Oct 31 2011 — edited Oct 31 2011Hi,
In the following query the partition by and order by is given as NULL
select row_number() over (partition by null order by null) rn, a.*
from wfmtmp a;
Does it mean, there will be no partitioning or ordering applied to the window function?
Thanks
Arun