Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What is difference between pl and sql?

1049


What is trigger and stored procedure in sql?

1027


Why stored procedure is better than query?

938


How much does sql certification cost?

1079


What is the use of non clustered index?

986


What is a subquery in sql?

1033


what are the security recommendations while using mysql? : Sql dba

1111


How does join work in sql?

1005


Why we use triggers in mysql?

988


What jobs use sql?

978


what are the advantages of sql ? : Sql dba

1053


what is top in tsql? : Transact sql

1113


what are string data types? : Sql dba

1039


What are different types of keys?

1096


What is primary and foreign key?

1058