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
- 9756 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 inner join and outer join?
How to Execute a Package in PL/SQL.?
how to create a new view in mysql? : Sql dba
Is sql a scripting language?
what is top in tsql? : Transact sql
Explain the the update statement in sql?
Can triggers stop a dml statement from executing on a table?
How many types of tables are there?
What is nvarchar max in sql?
Why is sql*loader direct path so fast?
Can dml statements be used in pl/sql?
What is the difference between the implicit and explicit cursors?
What are the different types of database management systems?
What is recursive stored procedure?
What are the three pl sql block types?
