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
);

What is ON DELETE CASCADE?

3 Answers  

What is the location of pre_defined_functions.

0 Answers  

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,

What is the basic form of sql query?

0 Answers  

What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?

1 Answers  

Does pl/sql support create command?

0 Answers  

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

What are the disadvantages of file system?

0 Answers  

What is the current version of sql?

0 Answers  

Is join and inner join the same?

0 Answers