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
10544 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 is autocommit sql?

1001

What is the difference between clustered and non-clustered indexes?

1098

how to create a new table by selecting rows from another table in mysql? : Sql dba

1117

What is difference between stored procedures and application procedures?

1023

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

963

Why use stored procedures?

1098

What is cost in sql execution plan?

994

What is database sql?

1059

Mention what pl/sql package consists of?

1006

How does left join work in sql?

1012

What company owns postgresql?

1038

what is the difference between $message and $$message? : Sql dba

1005

What is a data manipulation language?

1029

How would you convert date into julian date format?

1010

Is sql microsoft?

1062