Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 10521 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
Why do we use procedures?
How do I run sql?
Why do we need databases?
How do I access sql anywhere database?
Does normalization improve performance?
what is the command line end user interface - mysql? : Sql dba
discuss about myisam key cache. : Sql dba
how many ways we can we find the current date using mysql? : Sql dba
How do I run a pl sql procedure in sql developer?
Whis is not false in primary key?
Can I learn sql in a week?
Does execute immediate commit?
What is meant by cursor in sql?
Can a primary key be a foreign key?
What is trigger and how to use it in sql?
