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  

---

How can a function retun more than one value in oracle with proper example?

0 Answers  

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

0 Answers  

---

Difference between DBMS and RDBMS...CODD's rules

4 Answers   Polaris,

---

---

What is 19 null in sql?

0 Answers  

---

What is a database event trigger?

0 Answers  

---

What is Difference between StoredProcedure and function?

3 Answers  

---

How do I debug a stored procedure?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---

What is case function?

0 Answers  

---