SQL help

by "Srinivasan Ramakrishnan" <srinivar(at)md3.vsnl.net.in>

Date:	Mon, 17 Jul 2000 19:01:23 +0530
To:	<Undisclosed-Recipient:(at)md3.vsnl.net.in;>
	todo: View Thread, Original

Hi,

I had the following problem for a class test in College, I'd like to know
how
to solve it please help.


Write the sql statement for the following queries:

a) Display the employee's number and name whose salary is greater than the
average salary of *HIS DEPARTMENT*

b)Display the last name, dno, deptname of all employees

c)Display the employee's number and name whose salary is greater than  his
manager's salary.

*The mgr field stores the eno of the manager *

The tables are

1) employee(eno,fname,mname,lname,sex,sal,mgr,dno,dob,doj)
2)dept_scheme(dno,dname,loc)


-Srini

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA