Self join help..

From: <shirushah_at_my-dejanews.com>
Date: Sun, 08 Nov 1998 05:39:41 GMT
Message-ID: <723aqt$g8c$1@nnrp1.dejanews.com>

Need a list of all enames and their empno's who manage more than one person. For eg. need a statment that will show me only King, Blake & James as they manage more than 2 people.

Data from employee table:
EMPNO ENAME MGR
------ ---------- ---------
7839 KING

  7698 BLAKE           7839
  7782 CLARK           7839
  7566 JONES           7839
  7654 MARTIN          7698
  7499 ALLEN           7698
  7844 TURNER          7698
  7900 JAMES           7698
  7521 WARD            7698
  7902 FORD            7566
  7369 SMITH           7902
  7788 SCOTT           7566
  7876 ADAMS           7788
  7934 MILLER          7782

Thanx Very Much..
Shiru S

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Nov 07 1998 - 23:39:41 CST