3 ms·
It seems to error out. select name, count(*) from queries having count(*) > 1 Column 'queries.name' is invalid in the select list because it is not cont
by jmelloy 13y ago
It seems to error out.
select name, count(*)
from queries
having count(*) > 1
Column 'queries.name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
- genwin 13y agoLike 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 )