multiple tricky query in sql server code example
Example: multiple tricky query in sql server
select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee );
select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee );