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
- 8295 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 are sql triggers used for?
Is sql pronounced sequel or sql?
how many tables will create when we create table, what are they? : Sql dba
What is constant in pl sql?
How to make a copy values from one column to another in sql?
What is sql partition?
Are left and right joins the same?
Which tcp/ip port does sql server run on? How can it be changed? : Sql dba
What is package in pl sql with an examples?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
Explain the difference between sql and mysql.
Is pl sql a programming language?
How is data stored on a disk?
How do you clear the screen in sql?
Why stored procedure is better than query?
