Consider a table with 8 rows 4 rows contains value 0 and 4
rows contains value 1.Now write a single update query to make
all 0's as 1 and all 1's as 0
Answers were Sorted based on User's Feedback
Answer / ajay sharma
UPDATE mytable set mycolumn = (mycolumn + 1)%2
Is This Answer Correct ? | 21 Yes | 4 No |
Answer / vicky
Update test01 Set num =(case num when 1 then 0 when 0
then 1 else 3 end)
Is This Answer Correct ? | 10 Yes | 2 No |
Answer / shaheem ck
UPDATE <tablename>
SET <columnname> = DECODE(<columnname>,0,1,
1,0,
<columnname>);
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / madhu sudhan g
Hiii Lets take a table Test contains one field No having 8
rows in that 4 rows are with 0's and 4 rows with 1's to update
Update Test
SET No=case when 1 then o
else 1
ENd
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vernold
Update Table1 Set Column = case when Column = 1 then 0
when column = 0 then 1
Is This Answer Correct ? | 5 Yes | 7 No |
Answer / krishna reddy l
update example set column1 = case when column1=0 then 1
when column1=1 then 0 end
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / vicky saini
Update (tablename) set (coulmn name)=1 where (coulmn name)
=0
Is This Answer Correct ? | 1 Yes | 6 No |
Tell me what is difference between view and materialized view?
Why Do you want to work in this company?
Explain few examples of stored procedure over triggers?
What is dml command?
What is ACID Property of Transaction?
How to find the second highest salary of an employee?
What is a trace frag?
How can I know what locks are running on which resource?
What are constraints in microsoft sql server?
How do I trace a query in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
what is database replicaion? : Sql server database administration