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
- 9486 Views
- I also Faced
- E-Mail Answers
Answer Posted / preeti mishra
update T
set A:=A+B,
B:=A-B,
A:=A-B;
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What is user in sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What are the types of sql commands?
What is form and report?
What is audit logout in sql profiler?
What are the different ways to optimize a sql query?
List the different type of joins?
What is sql select statement?
Is sql dba a good career? : SQL DBA
How many types of triggers are there in pl sql?
What is the sql*loader? : aql loader
what is rdbms? : Sql dba
What is interval partition?
How many triggers can be applied to a table?
Can a select statement fire a trigger?
