UPDATE (SELECT t1.col1 c1, t2.col1 c2 FROM table1 t1, table2 t2

how can we replace the particular column value of a resulted
set of executed query? I mean write down a sql query to
chane the particular column's value of a resulted set of
executed query

Question Posted / mglbayar

3 Answers
6430 Views
I also Faced
E-Mail Answers

Answer Posted / mglbayar

UPDATE (SELECT t1.col1 c1, t2.col1 c2
FROM table1 t1, table2 t2
WHERE t1.pk = t2.fk AND more_condition)
SET c1 = c2;

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is $$ in sql?

971

What is the size of partition table?

1027

What view means?

961

How to call a javascript function from pl sql?

1118

What is sql comments?

1059

How to run sql statements with oracle sql developer?

1046

What is schema in sql?

926

what is 'mysqlshow'? : Sql dba

1005

What is a sql profiler?

1001

How do I count rows in sql?

979

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

1008

What is trigger explain with example?

1015

Why do we use partitions in sql?

1032

What is the usage of nvl function?

1024

Name three sql operations that perform a sort.

987