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
- 10545 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 is a trigger? : Sql dba
What are all the different normalizations?
What are types of joins?
What is union and union all keyword in sql?
What is sql trigger example?
Why commit is not used in triggers?
Is it possible to sort a column using a column alias?
Can delete statement be rollbacked?
i have some prob lem to tell me about my self in interview first round ...
Why is there a need for sqlcode and sqlerrm variables?
What is pl sql collection?
What is thread join () in threading?
Is sql a dbms?
Can we create table in function?
What is sp_helptext?
