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
9762 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 pl sql script?

1082

Where is all the data on the internet stored?

1056

What are stored procedures used for?

1049

What is difference between pl and sql?

1109

How to write pl sql program in mysql command prompt?

1163

What are the various restrictions imposed on view in terms of dml?

1017

what is a database transaction? : Sql dba

1255

What is a natural join sql?

1038

how can we find the number of rows in a table using mysql? : Sql dba

1123

What are sql objects?

1127

What is union and union all keyword in sql?

1109

What is sqlite format?

1259

What are the parts of a sql statement?

1143

What is sql entity?

1170

Write a query to display the current date in sql?

1076