it is a challenging question to any one

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

Question Posted / rm

8 Answers
9793 Views
I also Faced
E-Mail Answers

Answer Posted / rm

it is a challenging question to any one

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql entity?

1177

What are the popular database management systems in the it industry?

1045

What does an inner join do?

1252

What is nested table in pl sql?

1123

What is the difference between a primary key and a unique key?

1108

Is and as keyword in pl sql?

1016

what is csv? : Sql dba

1053

What is the difference between count 1 and count (*) in a sql query?

1057

What does truncate mean in sql?

1086

What do you understand by pl/sql packages?

1109

What are the limitations of sql express?

1126

Why is partition used in sql?

1190

how many triggers are allowed in mysql table? : Sql dba

1107

Explain what is a database?

1136

How do I run a program in pl sql?

1057