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
- 10696 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 dynamic query?
what is difference between delete and truncate commands? : Sql dba
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Why do we need view in sql?
Which version of sql do I have?
Can we use update in sql function?
What is the difference between a query and a report?
Define sql delete statement.
what is isam? : Sql dba
what is a materialized view? : Sql dba
Is oracel sql developer written in java?
How to change sql*plus system settings?
How to return multiple rows from the stored procedure?
i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5
Why is sharding used?
