Delete a single value from table

Posted by Chaithragm under Sql Server on 3/14/2013 | Points: 10 | Views : 2675 | Status : [Member] | Replies : 5

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

i want sql query to delete ward
here is the columns of wardwise table
zone wards
south -w1
south -w2
south -w3
North -w1
North -W2
North -w3

i want to delete w1 from wardwise where zone=south
if i do so w1 from north is also deleted

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 3/14/2013 [Member] [MVP] Bronze | Points: 25

0	hi try this Query Select * from tablename where Wards='w1' and Zone='south' mark as answer this useful to you. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Chaithragm, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Murugavelmsc on: 3/14/2013 [Member] Starter | Points: 25

0	delete from wardwise where Wards='w1' and Zone='south' Regards, Murugavel S murugavel.sadagopan@gmail.com http://murugavelmsc.blogspot.in/ Chaithragm, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sqldev on: 3/15/2013 [Member] Starter | Points: 25

0	Hi, Try the below code. DELETE FROM wardwise WHERE wards = 'w1' AND zone= 'south ' This code will use both the conditions and it will delete only 1 record which you want to delete. Hope this information helps you. Wth Best Regards, SQL Blogger http://learnsqltips.blogspot.com/ http://www.youtube.com/user/TheSSScreations Chaithragm, if this helps please login to Mark As Answer. \| Alert Moderator

Hi,

Try the below code.


DELETE FROM wardwise 

WHERE wards = 'w1' 

AND zone= 'south '

This code will use both the conditions and it will delete only 1 record which you want to delete.

Hope this information helps you.

Wth Best Regards,
SQL Blogger
http://learnsqltips.blogspot.com/
http://www.youtube.com/user/TheSSScreations

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sandeepmhatre on: 4/11/2013 [Member] Starter | Points: 25

0	DECLARE @table TABLE (dataVARCHAR(20)) INSERT INTO @table VALUES ('not duplicate row') INSERT INTO @table VALUES ('duplicate row') INSERT INTO @table VALUES ('duplicate row') SET ROWCOUNT 1 DELETE FROM @table WHERE data = 'duplicate row' SET ROWCOUNT 0 Sandeep M, Software Developer Follow me on : http://sandeepmhatre.blogspot.in Chaithragm, if this helps please login to Mark As Answer. \| Alert Moderator

DECLARE @table TABLE (dataVARCHAR(20))

INSERT INTO @table VALUES ('not duplicate row')

INSERT INTO @table VALUES ('duplicate row')

INSERT INTO @table VALUES ('duplicate row')

SET ROWCOUNT 1

DELETE FROM @table WHERE data = 'duplicate row'

SET ROWCOUNT 0

Sandeep M,
Software Developer
Follow me on :
http://sandeepmhatre.blogspot.in

Chaithragm, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 5/11/2013 [Member] Starter | Points: 25

0	DELETE FROM WARDS WHERE WARD='W1' ZONE='SOUTH' sriram Chaithragm, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts