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
- 7 Answers
- 8107 Views
- PMAM IT Services, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Why transaction is important?
What is linked report?
How to make a column nullable?
What is the difference between clustered and non-clustered indexes in ms sql server?
what method you can use to reduce the overhead of Reporting Services data sources?
Can truncate be rolled back?
What is service broker?
What are sql server functions?
What is difference between stored procedure and user defined function?
What is an indexing strategy?
What is abstracting periodical?
What does select 1 mean?
How efficient you are in oracle and SQL server?
Tell me what is difference between view and materialized view?
How to display a past time in days, hours and minutes?
