Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 9832 Views
- PMAM IT Services, TCS, I also Faced
- E-Mail Answers
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
What is application role in sql server database security? : sql server security
What will be the maximum number of index per table?
What is identity?
What is 3nf normalization form?
What is the purpose of optimization?
What are the 2 types of classifications of constraints in the sql server?
Tell me can we use custom code in ssrs?
How to list all login names on the ms sql server?
How can you stop stored procedures from recompiling?
What happens if null values are involved in string operations?
What are the different types of backups avaialabe in sql server 2005?
What is lock escalation and what is its purpose?
Can multiple columns be used in sql group by clause in ms sql server?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
Why use sub query in sql server and list out types of sub queries?
