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 / krish

DELETE FROM tablenameWHERE columnname AND columnname

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

528


What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

694


What are the properties of primary key?

523


Define compound operators?

537


What is report snapshot in ssrs?

166






What are the two modes of authentication in sql server?

526


How can you insert null values in a column while inserting the data?

722


What do you mean by a Composite primary key?

598


How to get the query of a table in sql server?

504


What is subquery in sql?

573


What are sql azure firewall rules?

85


What is left outer join in sql server joins?

556


How to join two tables in a single query in ms sql server?

542


How to display a past time in days, hours and minutes?

577


What is a coalesce function?

669