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
- 9507 Views
- I also Faced
- E-Mail Answers
Answer Posted / soma
Update Sales_summary set sales = s2.sales
From Sales_summary s1,
(
Select Region, max(sales) sales
From sales_data group by Region
)s2
where s1.Region = s2.Region;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Which join is like an inner join?
What is an exception in PL/SQL? What are the two types of exceptions?
Can we insert in sql function?
What is query optimization in sql?
Define join and name different types of joins?
which operator is used in query for pattern matching? : Sql dba
How to get help at the sql prompt?
What is sqlcommand?
What does inner join mean?
What is AUTH_ID and AUTH_USER in pl/sql ?
Is sql scripting language?
What is not equal in sql?
What pl/sql package consists of?
What is schema in sql?
