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
- 3 Answers
- 5886 Views
- I also Faced
- E-Mail Answers
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 the advantage of index in sql?
List the various privileges that a user can grant to another user?
How to get list of all tables from a database?
What is meant by cursor in sql?
What are the different types of triggers?
What is use of package in pl sql?
what are the 'mysql' command line arguments? : Sql dba
What are the advantages of indexing?
What is error ora-01000: maximum open cursors exceeded
what are all different types of collation sensitivity? : Sql dba
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is your daily office routine?
what are the security recommendations while using mysql? : Sql dba
How to run sql statements through the web interface?
Is merge a dml statement?
