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
9776 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

what are the features and advantages of object-oriented programming? : Sql dba

1073

What is cross join sql?

964

How would you convert date into julian date format?

1044

what are the security recommendations while using mysql? : Sql dba

1180

How does pl sql work?

1008

How to get help at the sql prompt?

1163

what is self-join? : Sql dba

1240

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1132

What is partition by in sql?

1127

What does select count (*) mean in sql?

1075

Is mariadb nosql?

1090

What is the difference between microsoft access and sql?

1075

How to take user input in pl sql?

1204

How do I access sql anywhere database?

1022

What is the trigger in sql?

1004