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
- 8551 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 are the types of operators available in sql?
What is embedded sql what are its advantages?
What is the reports view in oracle sql developer?
What does closing a cursor do?
What is rename command in sql?
What is cursor and its types?
what are the advantages and disadvantages of views in a database? : Sql dba
What is the difference between microsoft access and sql server?
what is the difference between truncate and delete statement? : Transact sql
Write a sql query to convert all character to uppercase after hypen.
How to use distinct and count in sql query? Explain
How do you change a value in sql?
How do I save the results of sql query in a file?
How do I count rows in sql?
How do I restart sql?
