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
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
Can you sum a count in sql?
What does rownum mean in sql?
how can we optimize or increase the speed of a mysql select query? : Sql dba
What are all the different normalization?
What is pls integer?
How do I create a sql database?
Why we use cross join?
What is data profiling in sql?
What is the difference between clustered and non-clustered index in sql?
what is difference between delete and truncate commands? : Sql dba
Difference between table function and pipelined function?
Does execute immediate commit?
Explain raise_application_error.
What is localdb mssqllocaldb?
Why function is used in sql?