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

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL: How Many Diff JOBs for each ENAME

Re: SQL: How Many Diff JOBs for each ENAME

From: sybrandb <sybrandb_at_gmail.com>
Date: 14 Nov 2006 10:21:40 -0800
Message-ID: <1163528500.141231.281250@m7g2000cwm.googlegroups.com>

klabu wrote:
> Using ONLY the structure of EMP as example,
>
> I have many, many employees in EMP and ENAME is not unique of course.....
> How to find HOW MANY DIFFERENT JOBs for each ENAME (non-key)
>
> 10gR2
>
> thanks

Apart from not reading the manual, are you now heading into a complete nuisance by posting all your homework too?

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Nov 14 2006 - 12:21:40 CST

Original text of this message

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