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

List and explain the different types of join clauses supported in ansi-standard sql?

1301

What is normalization? How many normalization forms are there?

1014

How does one load ebcdic data? : aql loader

1095

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1095

How do you modify a column in sql?

943

What is dynamic query?

915

How to use sql*plus built-in timers?

1097

What is a database event trigger?

1086

Is left join faster than inner join?

1065

What are the benefits of pl sql?

1055

How do I pipe the output of one isql to another?

945

Why having clause is used in sql?

931

Explain the order of sql statement execution?

980

What is the best partition size for windows 10?

947

What is pl sql architecture?

924