EXAMPLES FOR PRINTING “ROW NUMBERS” WITH “ORDER BY OPTION”

SELECT ROW_NUMBER() OVER (ORDER BY A.FULL_NAME),
    FULL_NAME,
    EMP_ID
    FROM EMP_TABLE A
ORDER BY A.FULL_NAME