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  

---

How many commands are there in sql?

0 Answers  

---

What is varchar sql?

0 Answers  

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

How to create your own reports in sql developer?

0 Answers  

---

---

how can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  

---

Is left join inner or outer?

0 Answers  

---

What is the difference between mdf and ndf files?

0 Answers  

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  

---

What is sql indexing?

0 Answers  

---

Which is the correct statement about truncate and delete?

0 Answers  

---

What is the purpose of my sql?

0 Answers  

---