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
- 8 Answers
- 8297 Views
- I also Faced
- E-Mail Answers
Answer Posted / keerthi
update Sales_summary
set Sales=(select max(Sales)from Sales_data where
Region=®ion) where Region=®ion;
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is user defined functions?
What packages(if any) has oracle provided for use by developers?
What is sqlservr exe?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Can a table have no primary key?
How to run pl/sql statements in sql*plus?
what is the difference between rownum pseudo column and row_number() function? : Sql dba
What is indexing in sql and its types?
How many tables can a sql database have?
Are subqueries faster than joins?
What are the possible values that can be stored in a boolean data field?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
What are the different types of a subquery?
Why do we use joins?
How to disable a trigger name update_salary?
