Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9211 Views
- I also Faced
- E-Mail Answers
Answer Posted / vipul garg
Update Sales_summary s1 set sales =
(
Select max(sales) sales
From sales_data s2
where s1.Region = s2.Region
);
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is mdf ldf and ndf?
What is an escape character in sql?
What is an implicit commit?
What is scope of pl sql developer in future?
What are inner and outer joins examples of both?
What is package in pl sql with an examples?
What are different categories of sql commands?
Why do we create views in sql?
How do you update a value in sql?
What is the difference between execution of triggers and stored procedures?
What is recursive stored procedure?
Explain the the update statement in sql?
How do you identify a primary key?
Does a join table need a primary key?
What is procedure explain with program?
