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,

---

Who is the owner of mysql database?

0 Answers  

---

How do you take the union of two tables in sql?

0 Answers  

---

What is primary key in db?

0 Answers  

---

How do I truncate a sql log file?

0 Answers  

---

What is percent sign in sql?

0 Answers  

---

what is the difference between cursor FETCH and FOR LOOP ?

3 Answers   CG-VAK, Tech Mahindra,

---

What has stored procedures in sql and how we can use it?

0 Answers  

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

0 Answers  

---

How are functions and procedures called in PL/SQL?

0 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

How is data stored in sql?

0 Answers  

---