How To Find Out Nth Highest Salary From Emp Table

How To Find Out Nth Highest Salary From Emp Table


  • 7 Feb, 2012

    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

    Comments Received:
    Please give your suggestions and feedback:

2009-2016 downloadmela.com. All rights reserved.