Types of joins ?

3 Answers   Digital GlobalSoft, HeadStrong,

---

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,

---

Difference between inline query and stored procedure?

4 Answers   Bharat, Microsoft,

---

What is the difference between join and natural join?

0 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

---

How do I count rows in sql?

0 Answers  

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

what are numeric data types? : Sql dba

0 Answers  

---

What are the types pl/sql code blocks?

0 Answers  

---

How to add, remove, modify users using sql?

0 Answers  

---

What is hibernate and its relation to sql?

0 Answers  

---

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

---