Update Sales_summary set sales = s2.sales From Sales

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 / soma

8 Answers
9219 Views
I also Faced
E-Mail Answers

Answer Posted / soma

Update Sales_summary set sales = s2.sales
From Sales_summary s1,
(
Select Region, max(sales) sales
From sales_data group by Region
)s2
where s1.Region = s2.Region;

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between partitioning and sharding?

950

Are stored procedures compiled?

873

How do I tune a sql query?

936

Explain the the update statement in sql?

990

How many types of tables are there?

901

What is an intersect?

1047

What is using in sql?

1019

Can we insert data in view?

891

how to use like conditions? : Sql dba

1040

What are the different types of a subquery?

984

What is the sql query to display the current date?

992

What is pl sql architecture?

924

What is replication id?

886

Which tcp/ip port does sql server run?

958

What is a database? Explain

1053