SQL :Oracle and PostgreSQL (No MySQL)

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.

Querying Clerk

 
Oracle

PostgreSQL