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

what are the different type of normalization? : Sql dba

968

Show code of a cursor for loop.

999

What is a temp table?

948

Is sql dba a good career? : SQL DBA

938

Explain aggregate functions are available there in sql?

938

what are date and time intervals? : Sql dba

998

What is a crud api?

899

what are the drivers in mysql? : Sql dba

981

What is normalization in sql?

961

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1005

Why is %isopen always false for an implicit cursor?

1032

How many functions are there in sql?

961

Do we need commit after truncate?

1025

Which one is better sql or oracle?

898

What is rownum and rowid?

982