RANK, DENSE RANK Analytic Functions Oracle Database|| xfactor
165 بار بازدید -
4 سال پیش
-
SELECT empno,
SELECT empno,
deptno,
sal,
RANK() OVER (PARTITION BY deptno ORDER BY sal) AS myrank,
DENSE_RANK() OVER (PARTITION BY deptno ORDER BY sal) AS myDenserank
FROM emp;
deptno,
sal,
RANK() OVER (PARTITION BY deptno ORDER BY sal) AS myrank,
DENSE_RANK() OVER (PARTITION BY deptno ORDER BY sal) AS myDenserank
FROM emp;
4 سال پیش
در تاریخ 1399/10/06 منتشر شده
است.
165
بـار بازدید شده