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


Please Help Members By Posting Answers For Below Questions

Does group by remove duplicates?

555


Why does sql need a server?

566


What is difference sql and mysql?

535


What is the purpose of design view?

529


What is a database? Explain

598






what is a trigger in mysql? Define different types of trigger. : Sql dba

558


what is text? : Sql dba

564


How do you modify a table in sql?

571


How many commands are in sql?

530


Why stored procedures are faster than query?

570


How to move files from one directory to another in pl sql?

644


How do you modify a trigger?

530


What is data definition language?

626


What is sql used for?

647


How many tables can a sql database have?

533