The question is to Fetch max(sales) from sales

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
9493 Views
I also Faced
E-Mail Answers

Answer Posted / rm

The question is to Fetch max(sales) from sales_data
and with this value update the sales column
in the sales_summary table.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is sql scripting language?

1051

What is primary and foreign key?

1063

what are the join types in tsql? : Transact sql

1064

what is bdb (berkeleydb)? : Sql dba

1034

what is the functionality of the function htmlentities? : Sql dba

960

What is informix sql?

975

How does sql*loader handles newline characters in a record? : aql loader

1044

What are the indexing methods?

1048

Which software is used for pl sql programming?

986

What packages are available to pl/sql developers?

1057

Differentiate between sga and pga.

1162

What are the sql commands?

1178

How do you update sql?

970

What are tables and fields in the database?

1111

Is primary key clustered index?

949