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 / m.raghu
by using sub query answer is
update table1 set col1=(select col2 from table2 where
<cond>)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are the types of join and explain each?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
Explain the working of foreign key?
what is the difference between a web-garden and a web-farm? : Sql dba
What are pl/sql cursors?
What is rtm stands for?
Why should I use postgresql?
How to combine two stored procedures in sql?
What is an exception in pl/sql?
What is the command used to fetch first 5 characters of the string?
What are triggers and its uses?
What is the difference between an inner join and an outer join?
What is crud diagram?
What is pessimistic concurrency control? : Transact sql
what is denormalization. : Sql dba