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
- 9217 Views
- I also Faced
- E-Mail Answers
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
What is the difference between local variables and global variables?
What are transaction and its controls?
If a cursor is open, how can we find in a pl/sql block?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
how to delete an existing column in a table? : Sql dba
Can we create view in stored procedure?
what is a database transaction? : Sql dba
how many values can the set function of mysql take? : Sql dba
What is a left inner join?
What do you understand by case manipulation functions?
What is sql scripting?
What are the different set operators available in sql?
Why are cursors used?
What is basic structure of pl sql?
Explain ttitle and btitle.
