what is a composite primary key ? : Sql dba

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  

---

Is sql open source?

0 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

how to get a list of indexes of an existing table? : Sql dba

0 Answers  

---

what is 'mysqlshow'? : Sql dba

0 Answers  

---

What is sql and its types?

0 Answers  

---

What is lookup table in sql?

0 Answers  

---

Explain some predefined exceptions.

0 Answers  

---

what is Hash join?how it is different from inner join?what is the sign used for inner join?(eg: like the (+) sign used for outer join)?

3 Answers   TCS,

---

what is the difference between primary key and unique key? : Sql dba

0 Answers  

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---