Answer / 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;

Answer / ajitnayak

update sales_sum s set sales =
(select max(sales) from sales_sum s2 where s.REGIN = s2.REGIN group by REGIN );

Answer / krishna

SQL> desc a;
Name Null? Type
------------------------------- -------- ----
A VARCHAR2(2)
B NUMBER(3)

SQL> select * from a;

A B
-- ---------
N 500
N 800
N 600
W 899
W 458
W 900

6 rows selected.

SQL> desc b;
Name Null? Type
------------------------------- -------- ----
A VARCHAR2(2)
B NUMBER(3)

SQL> select * from b;

no rows selected

SQL> insert into b (select a, max(b) from a group by a);

2 rows created.

SQL> select * from b;

A B
-- ---------
N 800
W 900

SQL>

Answer / 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

Answer / rm

The question is to Fetch max(sales) from sales_data
and with this value update the sales column
in the sales_summary table.

Answer / keerthi

update Sales_summary
set Sales=(select max(Sales)from Sales_data where
Region=&region) where Region=&region;

Answer / rm

it is a challenging question to any one

Answer / vipul garg

Update Sales_summary s1 set sales =
(
Select max(sales) sales
From sales_data s2
where s1.Region = s2.Region
);

Can we use threading in pl/sql?

0 Answers  

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

2 Answers  

How packaged procedures and functions are called from the following?

2 Answers  

What is the difference between a procedure and a function?

0 Answers  

What are the popular database management systems in the it industry?

0 Answers  

how to get a list of columns in an existing table? : Sql dba

0 Answers  

Differentiate between sga and pga.

0 Answers  

How can the performance of a trigger be improved?

0 Answers  

What trigger means?

0 Answers  

explain commit and rollback in mysql : sql dba

0 Answers  

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

Is natural join same as inner join?

0 Answers