UPDATE T SET A = B, ENVDOR

If I have a table T with 4 rows & 2 columns A & B. A has
values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL
query which can Swap the values of A & B for all records.
(Do not use a sub-query)

Question Posted / amit

5 Answers
10719 Views
I also Faced
E-Mail Answers

Answer Posted / amit

UPDATE T
SET A = B, ENVDOR_NUMBERB = A

Is This Answer Correct ?

1 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does mysql_real_escape_string prevent sql injection?

995

Is it possible to pass parameters to triggers?

1164

What are sql data types?

1072

Is subquery faster than join?

1063

What packages are available to pl/sql developers?

1112

what is union? : Sql dba

1082

What is bulk compiling in pl/sql.?

1193

What is the reports view in oracle sql developer?

1045

is mysql query is case sensitive? : Sql dba

1164

Is oracel sql developer written in java?

1169

What is union, minus and interact commands?

1365

Which query operators in sql is used for pattern matching?

1012

What is linq to sql?

1180

What is pragma in sql?

1127

What is Collation Sensitivity ? What are the various type ?

1001