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
9422 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 normalisation in sql?

1041

What are different sql data types?

1017

How do you drop a trigger?

967

What is difference between table and view?

1033

What is field delimiter?

1035

What is a delimiter in sas?

1035

What is 19 null in sql?

936

What is the difference between python and sql?

973

how can we know the count/number of elements of an array? : Sql dba

1044

Explain what is sql?

1097

What is schema in sql?

928

What is the use of & in pl sql?

1031

What are the key differences between SQL and PL SQL?

1198

what is 'mysqlshow'? : Sql dba

1007

What is record type in pl sql?

977