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
What does where 1/2 mean in sql?
How many tables can you join in sql?
Why do we use joins in sql?
Describe sql comments?
what is 'mysqlcheck'? : Sql dba
Why do we need pl sql?
How many databases can sql express handle?
Are there any features that are decommissioned in 11g that are not present in 11g?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
How many disk partitions should I have?
Explain the working of primary key?
Why truncate is used in sql?
Mention what are the benefits of pl/sql packages?
What are the 3 types of behavioral triggers?
Does group by remove duplicates?