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

Is sql open source?

970

What are the types of records?

988

What does the base_object_type column shows in the user.triggers data dictionary view?

1046

What is the primary use of normalization?

1000

Why is partition used in sql?

1117

What are all the ddl commands?

1177

Is sqlite free?

964

What is sql in java?

1074

What are the types of join and explain each?

1031

What is row_number () in sql?

978

what is msql? : Sql dba

988

Can we rollback after truncate?

1027

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

1061

What is the meaning of disabling a trigger?

1172

Why is sql better than hql?

981