How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query.

Answer Posted / subramaniam

Rupa Bagherwal is told the answer is correct
we cant delete particular value in one column
we can update onle

delete from employee where employeeid=2

suppose we wil give like this means it will delete one row

for this questions update only possible

Is This Answer Correct ?    31 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to provide default values to stored procedure parameters?

581


What is self contained scalar sub query?

542


What is the status of services on passive node for failover cluster in sql server? : sql server database administration

639


Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

106


Does group by or order by come first?

546






If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?

674


How to Insert multiple rows with a single insert statement?

551


What are the advantages of using stored procedures in sql server?

512


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

579


What stored by the master? : sql server database administration

583


What is filtered index?

660


What are cascading parameters in ssrs reports?

176


What do we have to check in database testing?

585


Explain intellisense for query editing

569


What is the difference between cartesian product and cross join?

483