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

What is the difference between local variables and global variables?

1106

Explain what is an index?

1034

What is pl sql in dbms?

934

Is pl sql different from sql?

967

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1144

What is a table partition?

1105

what are all the common sql function? : Sql dba

1041

What are the features of pl sql?

1046

Mention what is the function that is used to transfer a pl/sql table log to a database table?

969

What is the use of function in sql?

1067

What are types of joins?

947

What are the types of records?

977

What is function and procedure?

1016

How global cursor can be declare with dynamic trigger ?

2186

Is sql developer case sensitive?

978