Re: SQL: How Many Diff JOBs for each ENAME

klabu schrieb:
> 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
>
>
>

Either this is as simply as
SELECT COUNT(DISTINCT job),ename
FROM emp
GROUP BY ename;

or i didn't undertstand your question.

Best regards

Maxim Received on Tue Nov 14 2006 - 11:16:42 CST