Help with AVG SQL

Associate
Joined
2 Oct 2003
Posts
2,121
Location
Chester
I just cannot figure out how to select all Names where their Salary is greater than the Average for their DeptID.

Table structure is:

EmpID
Name
Salary
DeptID

Can anyone help please?
 
Back
Top Bottom