A reader, October 29, 2008 - 3:14 pm UTC
Tom:
I didn't understand this. Could you please explain what's partitioned?
October 29, 2008 - 4:26 pm UTC
nothing is partitioned.
If you say
Over (partition by 'flying toaster ovens' ... )
that is the same as saying
over ( /* this space left blank */ ... )
it is the same as NOT having a partition clause really.
Scott, October 29, 2008 - 4:49 pm UTC
Try
SELECT DEPTNO,EMPNO,
DENSE_RANK () OVER(PARTITION BY deptno ORDER BY empno ) RNK
FROM EMP
/
October 29, 2008 - 7:41 pm UTC
why?
that is basically their first query, with the case changed a tiny bit.