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
- 9023 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
Explain mutating table error.
Can a commit statement be executed as part of a trigger?
What is varchar data type in sql?
Can we use ddl statements in stored procedure sql server?
How do you go back in sql?
Why do we use joins?
What are reports usually used for?
What is the use of prepared statement?
How to test for null values?
how to check myisam tables for errors? : Sql dba
What are tables and fields?
Can we rollback delete command?
How to call a javascript function from pl sql?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
What do you mean by stored procedures?
