SQL Language (MOSC)

MOSC Banner

hierarchical query

edited Jan 31, 2012 7:58AM in SQL Language (MOSC) 8 commentsAnswered
Hi,Can someone help explain why is this.

SELECT last_name
  FROM employees
 WHERE department_id = 110

LAST_NAME
-----------
Higgins 
Gietz   

SELECT last_name
  FROM employees
 WHERE department_id = 110
CONNECT BY PRIOR employee_id = manager_id

LAST_NAME
----------
Higgins 
Gietz   
Higgins 
Gietz   
Gietz   
Higgins 
Gietz   

Why am I getting duplicate rows?

Thanks in advance,
Sha

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center