Re:Our SQL interview questions
by jmelloy on Tuesday May 28, 2013 @08:26PM
(#5783804)
It seems to error out.
Column 'queries.name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
[ Parent
| on HN ]
Like this. There is more than one way to do it:
-- List employees who have the biggest salary
-- in their departments
select
Name
from
Employees e1
where
exists
(
select
1
from
Employees e2
where
e2.DepartmentID = e1.DepartmentID
having
max(e2.Salary) = e1.Salary
)