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
- 9783 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunil
-- It can be done by simple procedure
DELIMITER $$
drop procedure if exists updatesale$$
create procedure updatesale()
BEGIN
declare l_loop_end INT default 0;
declare l_region varchar(10);
declare l_sale int ;
declare cur_1 cursor for select region 'Region',max(sales)
'SALES' from sales_data group by region;
declare continue handler for sqlstate '02000' set l_loop_end
= 1;
open cur_1;
repeat
fetch cur_1 into l_region,l_sale;
if not l_loop_end then
update sales_summery set sales=l_sale where region=l_region;
end if;
until l_loop_end end repeat;
close cur_1;
end$$
DELIMITER ;
call updatesale;
-- now check
select * From sales_summery;
region sales
w 900
N 800
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the sql*loader? : aql loader
What are the qualities of 2nf?
Why use truncate instead of delete?
Which constraints we can use while creating database in sql?
how to write date and time literals? : Sql dba
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
What is self-join and what is the requirement of self-join?
What is use of package in pl sql?
What is right join in sql?
What does stand for in sql?
Explain what is dbms?
What is the difference between a query and a report?
How many triggers can be applied on a table?
What trigger means?
