Home » Other » General » Question about neasted queries
Question about neasted queries [message #104576] Thu, 02 December 2004 20:16 Go to next message
Vishal V. Brahmakar
Messages: 1
Registered: December 2004
Junior Member
Consider the employees table is there with various manager_id, job_id. What wolud be the soln for the following one.

Write a query to display the following for those employees whose manager ID is less than 120:
a)manager ID
b)Job ID & total salary for every job ID for employees who report to the same manager.
c)Total salary of those managers
d)Total salary of those managers, irrespective of job IDs
Re: Question about neasted queries [message #104581 is a reply to message #104576] Sat, 04 December 2004 03:40 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

We're not going to do your Homework for you. Try to
write the queries yourself. If you have problems, and
you can show that you've tried, you are welcome to
post them there.

Best regards.

Frank
Previous Topic: CAD needs Oracle's HELP !
Next Topic: Foreign Currency revaluation
Goto Forum:
  


Current Time: Fri Mar 29 09:11:34 CDT 2024