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

What are reports usually used for?

0 Answers  

---

What is percent sign in sql?

0 Answers  

---

How to add a column ‘salary’ to a table employee_details?

0 Answers  

---

Explain two virtual tables available at the time of database trigger execution.

1 Answers  

---

How do I write a sql query in pgadmin 4?

0 Answers  

---

What is asqueryable?

0 Answers  

---

How to find only %th Highest Sal

6 Answers   Infogain, Symphony,

---

Which sql most popular?

0 Answers  

---

What is a delimiter in sas?

0 Answers  

---

What is a recursive join sql?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

What are the different types of functions in sql?

0 Answers  

---