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
- 7891 Views
- I also Faced
- E-Mail Answers
Answer Posted / rm
The question is to Fetch max(sales) from sales_data
and with this value update the sales column
in the sales_summary table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is example of database?
Does pdo prevent sql injection?
How do I save a stored procedure?
What is trigger types of trigger?
Which software is used for pl sql programming?
what are the advantages and disadvantages of cascading style sheets? : Sql dba
Can we create view in stored procedure?
What is difference between left and right outer join?
how to drop an existing view in mysql? : Sql dba
write an sql query to find names of employee start with 'a'? : Sql dba
Explain the structure of pl/sql in brief.
What is delete command in sql?
What is on delete set null?
what is data control language? : Sql dba
How do I view a sql trace file?
