tag:blogger.com,1999:blog-5562253332413822713.post7838646694453534407..comments2024-02-19T10:26:36.166-08:00Comments on SQL Server Interview Questions: Delete from tables involved in a SQL JoinUnknownnoreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5562253332413822713.post-24369603370404723522020-08-01T15:51:11.266-07:002020-08-01T15:51:11.266-07:00what if the table you tent to delete are been refe...what if the table you tent to delete are been referenced by other objects ?Johansahttps://www.blogger.com/profile/03786975611899987695noreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-43152122818311563322015-10-15T01:10:51.150-07:002015-10-15T01:10:51.150-07:00Using CTC statement in Sql Server
with tbltem as(...Using CTC statement in Sql Server <br />with tbltem as(<br /> Select Row_Number() over(Partition by Name order by Name) as RowNumber,* from Employee)Delete from tbltem where RowNumber>1Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-20131139071725530462014-01-06T22:58:19.163-08:002014-01-06T22:58:19.163-08:00Some Friend asking about duplicate deletion.
I thi...Some Friend asking about duplicate deletion.<br />I think, Check your relation could be irrelevant or your joining could have mistake if you are working with Relation.<br /> Anonymoushttps://www.blogger.com/profile/17338432033297587190noreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-2004046265780192352013-10-23T14:09:03.771-07:002013-10-23T14:09:03.771-07:00@Anonymous May 13, 2013 at 1:20 PM:
Your query de...@Anonymous May 13, 2013 at 1:20 PM:<br /><br />Your query deletes all the matched records. But in the case where more than one of the same record if exists, deletion should be done leaving one record. In that case how should we perform deletion?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-21026730776588146072013-05-13T13:20:38.494-07:002013-05-13T13:20:38.494-07:00delete Employees
from Employees
t1 inner join ...delete Employees <br />from Employees <br />t1 inner join Departments t2 on t1.DeptId = t2.Id<br /> where t2.Name = 'HR'Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-5562253332413822713.post-18993432586819029102012-09-07T12:42:10.632-07:002012-09-07T12:42:10.632-07:00how to delete duplicate records from table.how to delete duplicate records from table.Anonymousnoreply@blogger.com