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
9497 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 view the errors encountered in a trigger?

962

what is sql? : Sql dba

1030

Explain ddl statements in pl/sql?

1009

Can we use ddl commands in pl sql?

1162

Explain two easy sql optimizations.

1013

What is difference between stored function and application function?

1204

Explain what is table in a database?

1058

What is a record in pl/sql?

1148

What is the use of primary key?

1008

What is pivot query?

1073

What are the types of dbms?

975

how is myisam table stored? : Sql dba

1056

What is sap sql anywhere?

1079

What is rownum?

982

how to delete an existing column in a table? : Sql dba

1005