SQL: How Many Diff JOBs for each ENAME

Giganews Newsgroups
Subject: SQL: How Many Diff JOBs for each ENAME
Posted by:  klabu (noone_at_gmail_dot_com)
Date: Tue, 14 Nov 2006

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

Replies