UPDATE mytable set mycolumn = (mycolumn + 1)%2

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

Question Posted / ajay sharma

7 Answers
9829 Views
PMAM IT Services, TCS, I also Faced
E-Mail Answers

Answer Posted / ajay sharma

UPDATE mytable set mycolumn = (mycolumn + 1)%2

Is This Answer Correct ?

21 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is filter index?

951

What is use of @@ spid in sql server?

1211

How to recreate an existing index in ms sql server?

1051

What type of Index will get created after executing the above statement?

1099

How to enable/disable indexes?

1066

What is a database table?

970

What are the limitations in ssrs on sql server express edition?

186

Explain transaction server isolation?

1039

What is the function of inner join?

1069

What triggers long term care?

1029

What is meant by datasource?

921

What are the types of ssrs?

145

What is an index in sql?

1004

Explain what you mean by 3 tier architecture.

1077

Which are the olap features?

955