What is int identity in sql?

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  

---

What are the types of queries in sql?

0 Answers  

---

How do I add a database to sql?

0 Answers  

---

what are the performance and scalability characteristics of mysql? : Sql dba

0 Answers  

---

---

What is varchar data type in sql?

0 Answers  

---

Is time a data type in sql?

0 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

tell us something about heap tables. : Sql dba

0 Answers  

---

What is clause in sql?

0 Answers  

---

how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  

---

Can you have more than one key in a database?

0 Answers  

---