Thanks!
Here is what I have. I'm not sure what to put in the a.col, b.col part
select avg(emp.salary) as Exempt
from emp, job
where a.col = b.col
and job.exempt = 'Yes'
union
select avg(emp.salary) as Non-Exempt
from emp, job
where a.col = b.col
and job.exempt = 'No'
I have 2 tables, one for the employees name, salary,jobtitle and another table for the jobtitle description like exempt, min salary, etc...
I need a simple query statement for:
Calculate the avg salary for all exempt employees and non-exempt employees with the same statement.
Help!!
I have a cable going from my serial port to the console port on the server. I have all the secure crt settings correct, I turn on the server and nothing happens...What should appear on the screen?
Ok, I'm not sure if this is the right board for this, but I need some help. I have several Sun servers that I am liquidating for out of business companies. I need to login to the consoles to find out the server specs so I can sell them. I have no server experience. I have a laptop with WinXP...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.