Share my simple query using >= ALL
\nselect Department.Name as Department, e1.Name as Employee, Salary\nfrom Employee e1, Department\nwhere e1.DepartmentId = Department.Id \nand\nSalary >= ALL (s
<PRE><CODE>\nselect Department.Name as Department, e1.Name as Employee, Salary\nfrom Employee e1, Department\nwhere e1.DepartmentId = Department.Id \nand\nSalary >= ALL (select Salary from Employee e2 where e2.DepartmentId = e1.DepartmentId);\n</CODE></PRE>
[]