update Sales_summary 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 / keerthi

8 Answers
9781 Views
I also Faced
E-Mail Answers

Answer Posted / keerthi

update Sales_summary
set Sales=(select max(Sales)from Sales_data where
Region=&region) where Region=&region;

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you fetch common records from two tables?

1106

Explain the types of joins in sql?

1075

Does mysql support pl sql?

1233

How many databases can sql express handle?

1032

what is 'mysqld'? : Sql dba

1019

What is compound trigger?

1106

What packages(if any) has oracle provided for use by developers?

5883

how many sql ddl commands are supported by 'mysql'? : Sql dba

1066

How do I view stored procedures?

1023

Can we use two order by clause in query?

1017

What is pl sql quora?

1231

What is sql and its types?

1254

How many types of index are there?

1102

How to make a copy values from one column to another in sql?

1084

Is there any restriction on the use of union in embedded sql?

1200