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
- 8302 Views
- I also Faced
- E-Mail Answers
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 are different types of collation sensitivity? : Sql dba
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is t sql used for?
What are the advantages of pl sql over sql?
What is group by in sql?
Which is better varchar or nvarchar?
Can a view be mutating? If yes, then how?
what is the difference between group by and order by in sql? : Sql dba
Does truncate table reset auto increment?
How to use sql statements in pl/sql?
Name some usages of database trigger?
How to set up sql*plus output format in oracle?
What is meant by truncate in sql?
what are aggregate and scalar functions? : Sql dba
How do I view tables in mysql?
