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  

---

What is pivot in sql?

0 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

What do you understand by exception handling in pl/sql?

0 Answers  

---

What is the default isolation level in sql server? : Transact sql

0 Answers  

---

---

Is sql a programming?

0 Answers  

---

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

---

Why truncate is used in sql?

0 Answers  

---

What is sql partition?

0 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---

What is sql partition function?

0 Answers  

---

Explain exception handling in pl/sql?

0 Answers  

---