it is a challenging question to any one

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 / rm

8 Answers
9220 Views
I also Faced
E-Mail Answers

Answer Posted / rm

it is a challenging question to any one

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between nested table and varray?

944

Can we insert in view in sql?

1004

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1962

Are pl sql variables case sensitive?

1000

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1158

What are all the different normalizations?

972

What is a pdo connection?

948

What is the maximum rows in csv?

860

tell us something about heap tables. : Sql dba

1049

Is natural join same as inner join?

872

How exception is different from error?

971

What is the usage of sql functions?

1079

Is clustered index a primary key?

885

Are stored procedures faster than queries?

900

What do you understand by pl/sql packages?

1020