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
Answer Posted / vicky saini
Update (tablename) set (coulmn name)=1 where (coulmn name)
=0
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
How to insert multiple rows with one insert statement in ms sql server?
What is optimization and its types?
What is single-user mode?
What is built-in/administrator?
What is resource governor in sql server?
What is sqlservr.exe - process - sql server (sqlex?press)?
can a database be shrunk with users active? : Sql server administration
What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration
What is a file group?
What is the contrast amongst drop and truncate?
How to remove duplicate rows from table?
Explain different types of Normalization.
What is the difference between Clustered and Non-Clustered Index?
What different steps will a sql server developer take to secure sql server?
Why it is recommended to avoid referencing a floating point column in the where clause?