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

Report message to a moderator

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: 4581
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 05:51:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.