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
- 9485 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 composite primary key?
How many commands are there in sql?
How do you rename a table in sql?
Can a trigger call a stored procedure?
What is materialized view in sql?
Can a varchar be a primary key?
Can we use ddl statements in stored procedure sql server?
what is a database transaction? : Sql dba
Which is faster truncate or drop?
What is sql basics?
What is sql mysql pl sql oracle?
what are the advantages a stored procedure? : Sql dba
How to fetch alternate records from a table?
What are the different types of joins in sql?
How do you delete duplicates in sql query using rowid?
