suppose I have two table one Emp and other is dpt. Emp table has a field ,dept id,name ,sal and dpt table has a field dept id,dept name. Now I want to find out the emplyee list whose sal is between 2000-3000 from dept x.

7 Answers   Geometric Software, IBM,

---

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 an alias command?

0 Answers  

---

tell me about various levels of constraint. : Sql dba

0 Answers  

---

How do you get column names only for a table (sql server)?

0 Answers  

---

Can sql developer connect to db2?

0 Answers  

---

what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

What is composite data type in pl sql?

0 Answers  

---

what is cursor procedure

1 Answers   iGate,

---

Define union, minus, union all, intersect ?

0 Answers  

---