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 are the types of join and explain each?

1048


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1127


Explain the working of foreign key?

1067


what is the difference between a web-garden and a web-farm? : Sql dba

1081


What are pl/sql cursors?

1049


What is rtm stands for?

1100


Why should I use postgresql?

1017


How to combine two stored procedures in sql?

1237


What is an exception in pl/sql?

1089


What is the command used to fetch first 5 characters of the string?

1400


What are triggers and its uses?

1047


What is the difference between an inner join and an outer join?

1027


What is crud diagram?

948


What is pessimistic concurrency control? : Transact sql

1088


what is denormalization. : Sql dba

1113