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
- 7890 Views
- I also Faced
- E-Mail Answers
Answer Posted / soma
Update Sales_summary set sales = s2.sales
From Sales_summary s1,
(
Select Region, max(sales) sales
From sales_data group by Region
)s2
where s1.Region = s2.Region;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Sql technical questions
What is difference between table and view?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
What is a natural join sql?
What is compound trigger?
what is self join and what is the requirement of self join? : Sql dba
What is difference between rank () row_number () and dense_rank () in sql?
What does an inner join do?
what are the features and advantages of object-oriented programming? : Sql dba
What is the need of merge statement?
What are the different parts of a package?
Is sql easier than java?
Show the cursor attributes of pl/sql.
Explain select statements in sql?
