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


Please Help Members By Posting Answers For Below Questions

Why we use join in sql?

526


How many primary keys can a table have?

531


What is serial sql?

522


What is exception? What are the types of exceptions?

553


Explain cursor types?

578






What type of database is sql?

613


What is query optimization in sql?

544


How do I debug a stored procedure?

625


Can we have two clustered index on a table?

560


Can function return multiple values in sql?

522


what is query cache in mysql? : Sql dba

574


What is the difference between functions, procedures, and packages in pl/sql?

482


how to extract a unit value from a date and time? : Sql dba

556


What is sap sql?

532


How to create an array in pl/sql?

580