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
9794 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

Why partition by is used in sql?

1083

What is difference between pls_integer and integer?

1011

what are the features and advantages of object-oriented programming? : Sql dba

1075

How do you optimize a query?

1060

What is auto increment?

1048

What is localdb mssqllocaldb?

1115

What are the sql commands?

1233

what is an extent ? : Sql dba

1163

How many types of privileges are available in sql?

1409

What is trigger in sql and its types?

1113

Does a join table need a primary key?

1002

What is the difference between left and left outer join?

996

What is sql performance tuning?

982

What is the use of desc in sql?

1022

Is pl sql useful?

1039