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
Answer Posted / 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>
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Are there any features that are decommissioned in 11g that are not present in 11g?
Can we use update in sql function?
What is offset in sql query?
What is sql clause?
How to connect a sql*plus session to an oracle server?
What is fmtonly in sql?
How to get unique records from a table?
Why left join is used in sql?
What is bulk compiling in pl/sql.?
Can we insert data in view?
What is the unique index?
Is it possible to create startup or shutdown trigger for on-schema?
What is an exception in pl/sql?
What is forward declaration in pl sql?
How do I make my sql query run faster?