Home » SQL & PL/SQL » SQL & PL/SQL » Re: Hierarchial Queries
Re: Hierarchial Queries [message #19636] Tue, 02 April 2002 02:02
mohan
Messages: 16
Registered: August 2001
Junior Member
Try the following query

select empno, mgr, level from emp where level=(select max(level) from emp
start with empno=1 connect by prior empno = mgr)
start with empno=1 connect by prior empno = mgr;

Report message to a moderator

Previous Topic: updating a particular value in a record.
Next Topic: buffer over flows
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 03:47:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.