-
$ & $$ in Mapping or Parameter File
What is the difference between $ & $$ in mapping or parameter file? In which cases they are generally used?
-
-
Find out nth highest salary from emp table
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);For Eg:-Enter value for n: 2SAL---------3700