Hi Slimdave,

Thanks for the help. The below portion of the query is really not clear to me. Can you specify little more what is this and how it works.


Row_Number() Over Partition By
(d.deptno) dept_row

Thanks