List different type of expressions with the example.

0 Answers  

---

What are sql procedures?

0 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

write a query to find 4th max salary

7 Answers  

---

What do you understand by exception handling in pl/sql?

0 Answers  

---

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

Explain UNION,MINUS,UNION ALL, INTERSECT?

1 Answers  

---

Why use triggers in sql?

0 Answers  

---

What is sql used for?

0 Answers  

---

what is the stuff function and how does it differ from the replace function? : Sql dba

0 Answers  

---