If use MS SQL database
It should be
select top 4 salary from employees where salary!=(select max(salary) from employees) order by salary desc
Type: Posts; User: nomisspoint; Keyword(s):
If use MS SQL database
It should be
select top 4 salary from employees where salary!=(select max(salary) from employees) order by salary desc