Youtor
Abinitio Question 13 Rank function implementation in Abinitio
>> YOUR LINK HERE: ___ http://youtube.com/watch?v=DlBpF-rBuao
SELECT deptno, • ename, • sal, • RANK() OVER (PARTITION BY deptno ORDER BY sal) rank • FROM emp • WHERE deptno = 30; • DEPTNO ENAME SAL rank • ---------- ---------- ---------- ---------- • 30 JAMES 950 1 • 30 WARD 1250 2 • 30 MARTIN 1250 2 • 30 TURNER 1500 4 • 30 ALLEN 1600 5 • 30 BLAKE 2850 6 • 20 • 20 • Can you achieve it in Abinitio? • For Class notes please visit: • https://datapundittechblog.blogspot.c...
#############################
