SQL> desc a; Name Null? Type ---------

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

Question Posted / krishna

8 Answers
9426 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

Please Help Members By Posting Answers For Below Questions

what are aggregate and scalar functions? : Sql dba

1041

how to convert numeric values to character strings? : Sql dba

1085

What is trigger point?

977

Why use stored procedures?

1063

what is data integrity? : Sql dba

1020

What are the subsets of sql?

1103

What is over () in sql?

932

What is localdb mssqllocaldb?

1053

What is sql keyword?

981

What is the difference between subquery and correlated query?

1043

Why we use pl sql?

943

What is the purpose of using pl/sql?

1125

What is the use of index in hive?

990

who introduced sql?

999

How to rename a table?

998