update sales_sum s set sales = (select max(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 / ajitnayak

8 Answers
9792 Views
I also Faced
E-Mail Answers

Answer Posted / ajitnayak

update sales_sum s set sales =
(select max(sales) from sales_sum s2 where s.REGIN = s2.REGIN group by REGIN );

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is cursor and why it is required?

1256

What is sqlcommand?

1073

What is pl sql package?

1073

Can we edit a view in sql?

1047

What is sql partition function?

1292

What are the benefits of pl/sql packages?

1166

What are the different types of tables in sql?

1071

What are the most important ddl statements in sql?

1192

What are data types in pl sql?

1200

What are sql data types?

1072

What is snowflake sql?

1133

Can we use having without group by in sql?

1054

what is data manipulation language? : Sql dba

1071

What is an inner join sql?

1099

Why do we use %rowtype & %type in plsql?

1100