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 |
What is the difference between ddl and dml?
What is repeatable read?
in my server i have 3 instances,one of them got failed, and this cause we r not able to connect to server, how to know which instance was dameged?
What is a mixed extent?
What do you mean by tablesample?
Explain what role entity and relationship play in an ER diagram.
What is logon trigger?
hi i gone though satyam interview. what is Acid Properties?
What happens if null values are involved in bitwise operations?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
When we can say that is in BCNF?