-
How to retrieve 2nd highest sal in each departement from emp and dept tables using GROUP BY?
EMP table (empno,deptno,sal) DEPT table(deptno,dname) i need Deptno, Dname, 2nd_highest_sal_in_dept in output. I can easily do this using row_number, Rank,Dense_rank etc but I am unable to do this using Group By. Please suggest if this can be done using Group By.