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

How to find 3rd highest salary of an employee from the employee table in sql?

1080

How many commands are in sql?

1068

Is a foreign key always unique?

942

explain the difference between delete , truncate and drop commands? : Sql dba

1093

What is varchar sql?

1138

How many functions are there in sql?

1018

What is the use of prepared statement?

1017

how to drop an existing index in mysql? : Sql dba

1069

What is the starting oracle error number?

1052

Does truncate free space?

1008

What is sql exception?

973

What does the file extension accdb stand for?

970

What is the example of procedure?

928

what is rdbms? : Sql dba

1012

What is delimiter in pl sql?

1062