by using sub query answer is update table1 set col1=(select col2 from t

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

Question Posted / m.raghu

3 Answers
6558 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

Please Help Members By Posting Answers For Below Questions

How can I make sql query run faster?

1059

what are the different type of normalization? : Sql dba

1063

how can we destroy the cookie? : Sql dba

1074

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

3094

Explain polymorphism in pl/sql.

1168

What is procedure explain with example?

1003

What is the use of nvl function?

1239

How to sort the rows in sql.

1113

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1101

what's the difference between a primary key and a unique key? : Sql dba

1104

What are the main features of cursor?

1108

what are date and time functions in mysql? : Sql dba

1018

Is ms sql traffic encrypted?

957

What are secondary keys?

1028

Is trigger a stored procedure?

973