Hiii Lets take a table Test contains one field No having 8 rows in that 4

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 / madhu sudhan g

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can a user-defined datatype be created?

972

Explain about system database?

1043

How to find the service pack installed? : sql server database administration

1009

How can you start sql server in different modes?

952

Explain the properties of subqueries in sql server?

1057

What are different types of raid levels?

1141

Explain a join?

1046

How can we delete Duplicate row in table?

1038

What is default constraint?

976

Define Wed Edition in SQL Azure?

100

Why we use trigger in sql server with example?

943

Explain insert into select statement?

929

How to set database to be single_user in ms sql server?

1007

Explain about sql server login?

1065

How many primary keys are possible in a table?

908