Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ROOKIE needs HELP !

ROOKIE needs HELP !

From: C. & K. Rozema <chris.rozema_at_tip.nl>
Date: 1997/01/17
Message-ID: <01bc044e$97a40400$0b20b18f@t380935>#1/1

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....

-- 


*********************************************
Chris & Kirstin Rozema Almelo http://www.tip.nl/users/chris.rozema
*********************************************
Received on Fri Jan 17 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US