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,

---

what are the advantages of using stored procedures? : Sql dba

0 Answers  

---

what is the difference between delete and truncate commands? : Sql dba

0 Answers  

---

What is a constraint? Tell me about its various levels.

0 Answers  

---

Which join is like inner join?

0 Answers  

---

SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows

8 Answers   Sonata,

---

how many sql dml commands are supported by 'mysql'? : Sql dba

0 Answers  

---

What is structural independence and why is it important?

0 Answers  

---

How does sql store data?

0 Answers  

---

What is embedded sql in db2?

0 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---

How many triggers can be applied to a table?

0 Answers  

---