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
10443 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 is set serveroutput on?

1120

Why we use cross join?

938

Advantages and disadvantages of stored procedure?

1102

how to shut down the server with 'mysqladmin'? : Sql dba

990

What are expressions?

990

Define a temp table?

1004

Is microsoft sql free?

1083

What are inbuilt functions in sql?

1027

What is the difference between joins?

1023

What is pl sql architecture?

945

What is a sql statement?

939

Are pl sql variables case sensitive?

1032

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

1035

what is row? : Sql dba

1205

How do I create a sql script?

1085