Find the 4th Highest employee salary from the following table

Question

Find the 4th highest salary from the given employee table

in progress 0
sirajp99 2 months 1 Answer 75 views Newbie 0

Answer ( 1 )

  1. SELECT TOP 1 salary FROM ( SELECT DISTINCT TOP 4 salary FROM Employeetable ORDER BY salary DESC ) AS temp ORDER BY salary


    Attachment

Leave an answer

Browse
Browse