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
10304 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

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1125

What are expressions?

954

How do I write a sql query in pgadmin 4?

927

Is join an inner join?

898

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1003

What is composite data type in pl sql?

1035

How does a covering index work?

907

what is column? : Sql dba

962

discuss about myisam index statistics collection. : Sql dba

908

What does the argument [or replace] do?

1017

Which one is better sql or oracle?

904

What are the three pl sql block types?

949

What is forward declaration in pl sql?

1008

Can 2 queries be executed simultaneously in a distributed database system?

1084

Which join is like inner join?

978