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 is trigger and how to use it in sql?
Is join same as left join?
What is the basic structure of an sql?
what is sql server agent? : Sql dba
Explain what is a field in a database and record in a database?
What is sql and how does it work?
What are the different operators available in sql?
Can you inner join the same table?
What are the different types of functions in sql?
what is the difference between a having clause and a where clause? : Sql dba
How run sql*plus commands that are stored in a local file?
What is scope of pl sql developer in future?
What is a field in a database?
Why truncate is used in sql?
How do I view stored procedures?