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
- 8559 Views
- I also Faced
- E-Mail Answers
Answer Posted / avi007
select A as "B",B AS "A" from T;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How do you remove duplicate records from a table?
What are types of exception?
Is primary key clustered index?
What are the basic techniques of indexing?
what are the authentication modes in sql server? How can it be changed? : Sql dba
How do I count records in sql?
how to get @@error and @@rowcount at the same time? : Sql dba
What is trigger explain with example?
What is a primary key? Explain
What is mutating table error?
Why are sql stored procedures used?
How can you view the errors encountered in a trigger?
what does the t-sql command ident_incr does? : Transact sql
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
What is the difference between union and union all command?
