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
Answer Posted / rm
it is a challenging question to any one
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Why we use join in sql?
How many primary keys can a table have?
What is serial sql?
What is exception? What are the types of exceptions?
Explain cursor types?
What type of database is sql?
What is query optimization in sql?
How do I debug a stored procedure?
Can we have two clustered index on a table?
Can function return multiple values in sql?
what is query cache in mysql? : Sql dba
What is the difference between functions, procedures, and packages in pl/sql?
how to extract a unit value from a date and time? : Sql dba
What is sap sql?
How to create an array in pl/sql?