Home » SQL & PL/SQL » SQL & PL/SQL » plz give sol of this query
plz give sol of this query [message #208100] Fri, 08 December 2006 03:14 Go to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
show Dept_no,Dept_name,number of employees and average salary of all departments together with there names,salaries and job_ids of the employees working in each department. Here Dept_no and Dept_name are the fields of table Department and other are from Employees.
Plz give solution and explain it. Thakxxx
Re: plz give sol of this query [message #208103 is a reply to message #208100] Fri, 08 December 2006 03:24 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Homework due in today is it?
Re: plz give sol of this query [message #208104 is a reply to message #208100] Fri, 08 December 2006 03:24 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm sorry, but such a data is considered confidential.
Re: plz give sol of this query [message #208111 is a reply to message #208104] Fri, 08 December 2006 04:00 Go to previous messageGo to next message
amit_vass2000
Messages: 52
Registered: December 2006
Location: Delhi
Member
No sir, i think you are confused. Nothing is confidential in this. It is just i have seen this query in my oracle book. that's why i was asking solution from u. Plz do it Sir
Re: plz give sol of this query [message #208123 is a reply to message #208111] Fri, 08 December 2006 04:55 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I was just joking.

On topic: what is wrong with a query you found in the book? I mean, why would anyone write it? Do you plan to compare someone's solution with the one in the book?

Did YOU try to write it? If not, you should have. Then come back and say what bothers you (if anything).
Re: plz give sol of this query [message #208128 is a reply to message #208100] Fri, 08 December 2006 05:00 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi
read avout joining the tables , you can solve it .

bye
Ashu
Re: plz give sol of this query [message #208143 is a reply to message #208111] Fri, 08 December 2006 05:34 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
no you do it..if you face a problem we will help

[Updated on: Fri, 08 December 2006 05:35]

Report message to a moderator

Re: plz give sol of this query [message #208149 is a reply to message #208111] Fri, 08 December 2006 06:01 Go to previous message
swamimahi
Messages: 1
Registered: December 2006
Location: Pune
Junior Member
i have done some stuff may be this is helpfull to u
select dept.deptno,dept.dname,avg(emp1.sal) from dept,emp1 group by dept.deptno,dept.dname
Previous Topic: Lock on Drop User
Next Topic: issue of environment variable
Goto Forum:
  


Current Time: Sat Dec 10 09:05:00 CST 2016

Total time taken to generate the page: 0.04615 seconds