How can I build a filtered report that fetches all employees with salary greater than the average company salary? ...something like the following SQL statement:
"select employeeid, firstname, lastname, salary
from employee
where salary > (select avg(salary) from employee)"
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
bvelivela
How can I build a filtered report that fetches all employees with salary greater than the average company salary? ...something like the following SQL statement:
"select employeeid, firstname, lastname, salary
from employee
where salary > (select avg(salary) from employee)"
Link to comment
Share on other sites
1 answer to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.