SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Newbie help with SQL subqueries

635512Apr 22 2008 — edited Apr 22 2008

I'm trying to teach myself SQL with some basic material I found online.

I am using the standard HR user and associated tables.

I want to be able to find all the departments which have an average salary greater than the average salary of the company.

I just can't figure out in my mind how to make this one query. I can list the average salaries of each department, and I can list the average salary for the company, but I can't seem to compare each department average with the company average.

I am sorry this is such a basic question.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2008

Added on Apr 22 2008

3 comments

256 views