Trying to display first name, lastname, departmentname and salary of those personnel who's salary is above the average.SELECT e.Firstname, e.LastName, e.salary, d.departmentname as Employee , avg(e.salary) as salaries FROM Employeesf eright join departments d on e.departmentid = d.departmentid--where e.salary > avg(salaries)group by e.firstname, e.lastname, e.salary, d.departmentname
error:An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
yet another problem
Posted - 2011-02-15 : 12:44:40
