peter parker Member Member since Aug 21, 2011 Last active Aug 22, 2011 Total activities 0 Activity feed Recent contributions #Threads 14 years ago 867efb5b-4baa-44f0-b027-08d6b4f65454 the above query is the solution for second highest salary #Threads 14 years ago 434dcfad-4757-47d6-be72-0f0416007e8d select max(sal) from (select sal from emp where sal != (select max(sal) from emp))
