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
- 9755 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 difference between a database and a relational database?
What are the main features of cursor?
What is 19 null in sql?
What are the steps for performance tuning.
Can a table contain multiple primary key’s?
Does sql*plus have a pl/sql engine?
How many indexes can be created on a table in sql?
What is pivot in sql?
how many ways to get the current time? : Sql dba
what is the difference between sql and t-sql? : Transact sql
Can sql function call stored procedure?
Can you sum a count in sql?
What are user defined functions?
what is a foreign key ? : Sql dba
how to include numeric values in sql statements? : Sql dba
