SELECT empno, ename, sal, RANK()OVER (ORDER BY SAL) "V" FROM EMP WHERE JOB = 'CLERK'
Rank calculates rows and skips if there is a tie.