delete from tablename where columnname=datatype examples: dele

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

Question Posted / elumalai.k

Answer Posted / elumalai.k

delete from tablename where columnname=datatype
examples:
delete from employee where employeeid=2

Is This Answer Correct ?

13 Yes

71 No

Please Help Members By Posting Answers For Below Questions

Explain what are magic tables in sql server?

1002

How to delete all rows with truncate table statement in ms sql server?

1008

Tell me what is de-normalization and what are some of the examples of it?

1056

what's the difference between delete table and truncate table commands? : Sql server database administration

991

What are trace flags?

1038

Can you leave a union at any time?

1069

What is the difference between value type and reference type?

929

How to enable/disable indexes?

1072

If any stored procedure is encrypted, then can we see its definition in activity monitor?

995

How to create hyperlink from returned sql query ?

1132

What are user defined functions in ms sql server?

1010

How to change the name of a database user?

964

What is the difference between char, varchar and nvarchar?

1033

How do you set a trace flag in sql server?

1043

Can I use sql azure as a backup with log shipping or database mirroring?

156