CODE EXAMPLE FOR SQL

multiple tricky query in sql server

select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee );