Question { Cognizant, 361370 }
how to find the second highest salary from emp table?
Answer
Select level,Max(sal) from emp
Where level=&level connect by prior sal>sal
group by level;
ENTER THE LEVEL MANUALLY
EX:Enter value for level: 2
YOU GET SECOND MAXIMUM SALARY.