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)
- 5 Answers
- 8566 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
What is a heap in sql?
How exception handling is done in advance pl/sql?
Can I call a procedure inside a function?
what is primary key? : Sql dba
What is dynamic query?
What is partition by in sql?
How do I run a pl sql procedure in sql developer?
Define a temp table?
Is the primary key an index?
What version is sql?
Why partition by is used in sql?
Does sql support programming?
What is nvarchar in sql?
What is nosql db?
Can we use loop in sql?
