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 trigger and how to use it in sql?

1008


Is join same as left join?

1021


What is the basic structure of an sql?

1079


what is sql server agent? : Sql dba

1083


Explain what is a field in a database and record in a database?

1073


What is sql and how does it work?

1150


What are the different operators available in sql?

987


Can you inner join the same table?

979


What are the different types of functions in sql?

1037


what is the difference between a having clause and a where clause? : Sql dba

1062


How run sql*plus commands that are stored in a local file?

1039


What is scope of pl sql developer in future?

993


What is a field in a database?

1048


Why truncate is used in sql?

984


How do I view stored procedures?

958