Answer / abhijit

The start with .. connect by clause can be used to select
data that has a hierarchical relationship (usually some sort
of parent->child (boss->employee or thing->parts).


select a.*, level from emp a
start with mgr is null
connect by mgr = prior empno;

The start with .. connect by clause can be used to select
data that has a hierarchical relationship (usually some sort
of parent->child (boss->employee or thing->parts).

Answer / guest

Retrives rows in hierarchical order.
e.g. select empno, ename from emp where

Which is better join or subquery?

0 Answers  

---

How do you retrieve the second highest salary from a table?

3 Answers  

---

What is cursor in pl sql with examples?

0 Answers  

---

How to get help at the sql prompt?

0 Answers  

---

What is meaning of <> in sql?

0 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

What are different types of statements supported by sql?

0 Answers  

---

What is difference between sql and excel?

0 Answers  

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

Differences between UNIQUE and DISTINCT in select statements

26 Answers   ABS, DELL, Deloitte, Hewitt, Oracle, Verinon Technology Solutions, Wipro,

---

How to select all records from the table?

0 Answers  

---

What is sqlca in powerbuilder?

0 Answers  

---