Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ROOKIE needs HELP !
Hello specialists!
I'd like to call on you to help me with these 2 questions! First of all, I'm working with SQL and the table I use is:
SQL> desc emp
Name Null? Type ------------------------------- -------- ---- EMPNO NOT NULL NUMBER(4) ENAME VARCHAR2(10) JOB VARCHAR2(9) MGR NUMBER(4) HIREDATE DATE SAL NUMBER(7,2) COMM NUMBER(7,2) DEPTNO NUMBER(2) GEMSAL NUMBER(6)
The questions I'd like to answer are:
1)
How many people got hired in the year in which the most people got hired,
and how many people did get hired in that year?
2)
Give the empno's of the managers (job = ' MANAGER ' ) with an empno larger
than 7777, who have several subordinate's/inferiors/employees with the same
job.
Please help this Rookie to answer the last 2 answers of his 'homework'.
I'd like you to answer by email, because I don't have the time (due to this
problem)
to visit this newsgroup very often.....
Thanx for your time....
--Received on Fri Jan 17 1997 - 00:00:00 CST
*********************************************
Chris & Kirstin Rozema Almelo http://www.tip.nl/users/chris.rozema
*********************************************