select A as "B",B AS "A" from T;

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 / avi007

5 Answers
10291 Views
I also Faced
E-Mail Answers

Answer Posted / avi007

select A as "B",B AS "A" from T;

Is This Answer Correct ?

1 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are all the different types of indexes? : Sql dba

995

how would concatenate strings in mysql? : Sql dba

1011

What are the different types of dbmss?

962

Show code of a cursor for loop.

999

Can we group by two columns in sql?

942

What are the benefits of pl sql?

1049

What is sp_helptext?

1004

how would you get the current date in mysql? : Sql dba

911

How to fix oracle error ora-00942: table or view does not exist

954

how to fetch common records from two tables? : Sql dba

1105

Why is %isopen always false for an implicit cursor?

1034

What is a composite primary key?

1030

How do I run a pl sql procedure in sql developer?

911

Which are the different case manipulation functions in sql?

952

What is the difference between in and between in sql?

993