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

How do you modify a column in sql?

0 Answers  

---

What is the difference between left and left outer join?

0 Answers  

---

Describe different types of general function used in sql?

0 Answers  

---

what is called after appearing where clause

3 Answers  

---

What does select count (*) mean in sql?

0 Answers  

---

How do I add a database to sql?

0 Answers  

---

Can unique keys be null?

0 Answers  

---

How do I run sql?

0 Answers  

---

Can we use rowid as primary key?

0 Answers  

---

What is a cursor ? Why Cursor is required ?

3 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,

---

What is pivot table in sql?

0 Answers  

---