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
how to get @@error and @@rowcount at the same time? : Sql dba
Can we call dml statement in function?
What is join view in sql?
what is try_catch block in procedure
Explain the select statement in sql?
What is relationship? How many types of relationship are there?
What is the function that is used to transfer a pl/sql table log to a database table?
What are the types of dbms?
How to get each name only once from an employee table?
Is postgresql a nosql database?
Is sql port 1433 encrypted?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What is the difference between having and a where in sql?
How do you use join?
Where the sql database files are stored?