select * from emp m where(select COUNT(distinct salary) from emp s where s.salary>m.salary)=0
select * from emp where salary = (select Max(salary) from emp)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)