• Home
  • shruthyreddy Answers

Answered Questions

  • Mar 29 2006
    03:11 PM
    85675
    91

    How to find out department wise second maximum salary.
    • Srinu

    pinky

    • May 31st, 2017

    SELECT * FROM (SELECT DEPT_ID , DENSE_RANK(SALARY) OVER(PARTITION BY DEPT_ID ORDER BY SALARY ) DRANK FROM DEPARTMENTS ) WHERE DRANK = 2;

    KAMLESH

    • Dec 29th, 2016

    Code
    1. SELECT DEPARTMENT_ID,SALARY FROM
      2. 

    2. (SELECT DEPARTMENT_ID,SALARY,DENSE_RANK() OVER 
      3. 

    3. (PARTITION BY DEPARTMENT_ID ORDER BY SALARY DESC) 
      4. 

    4. AS RNK FROM EMPLOYEES) WHERE RNK=2;