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  

---

Does group by remove duplicates?

0 Answers  

---

What is gpt format?

0 Answers  

---

Can we change the table name in sql?

0 Answers  

---

Why partition by is used in sql?

0 Answers  

---

---

What is the process of debugging?

0 Answers  

---

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

---

How does postgresql compare to oracle/db2/ms sql server/informix?

0 Answers  

---

What is cursor in pl sql?

0 Answers  

---

What is rollback?

0 Answers  

---

What is an oracle stored procedure?

0 Answers  

---

How many scalar data types are supported in pl/sql?

0 Answers  

---