Answer / sharad kumar

select manager name,employee name,level
from table_name
start with manager name is null /* optional*/
connect by prior nocycle employee name = manager name
/*Child = Parent */

Answer / sankar

select manager name,employee name,level from table_name
start with manager_name is null/* optional */ connect by prior
no cycle employee name=manager name/*child=parent*/

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

Is sql harder than python?

0 Answers  

---

i have a table emp and columns ename,empno,mgr_id,i need ename,manager name as result i.e employee respective manager.. example empno ename mgr_id 1 john 3 2 paul 3 3 smith 1 4 kevin 1 5 stewart 2 result has to look like this ename manager john smith paul smith smith john kevin john stewart paul can u plz help me out in this.....

8 Answers  

---

Can we insert in view in sql?

0 Answers  

---

define join and explain different type of joins? : Sql dba

0 Answers  

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

Can we debug stored procedure?

0 Answers  

---

How do I run a sql query?

0 Answers  

---

How can we find duplicate records in a table?

0 Answers  

---

What are the PL/SQL Statements used in cursor processing ?

4 Answers  

---

What are the datatypes a available in PL/SQL ?

2 Answers  

---