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
- 9424 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
difference between anonymous blocks and sub-programs.
How you improve the performance of sql*loader? : aql loader
What is sql and how does it work?
What are types of indexes in sql?
What are local and global Indexes and where they are useful.
What is offset in sql query?
What does dml mean?
What is sql query optimization?
Is keyword pl sql?
How do I partition a table in sql?
What are the uses of merge?
What is the difference between row level and statement level trigger?
What is procedure explain with example?
Is a table valued function object?
Where is all the data on the internet stored?
