Home » SQL & PL/SQL » SQL & PL/SQL » How to Update the Col2 for below Table Structure
How to Update the Col2 for below Table Structure [message #674894] Thu, 21 February 2019 04:41 Go to previous message
sonudev
Messages: 26
Registered: November 2009
Location: bangalore
Junior Member
Hi,

We have the below structure for two tables. Now I want to sort out the below queries.

Tab1
C1 C2 C3
10 20 78
70 50 76
80 90 79

Tab2
C1 C2
10 X
70 Y
80 Z

How can we update C2 column of tab1 with the values as per second table tab2 ?
How to get max value from the table tab1?

Appreciate for valuable suggestions.

Thanks,
Sonu


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Connect by clause taking lot of time
Next Topic: difference amount between 2 dates
Goto Forum:
  


Current Time: Fri Mar 29 06:51:00 CDT 2024