For All Programming solution

Wednesday, January 9, 2013

How to delete Duplicate Record From a Table in SQL Server

DELETE TOP (SELECT COUNT(*) -1 FROM dbo.Emptest WHERE EmpID = 'Basharat')  FROM dbo.Emptest  WHERE EmpID = 'Basharat'
Posted by niaz at 2:54 AM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2024 (1)
    • ►  January (1)
  • ►  2023 (3)
    • ►  September (1)
    • ►  April (1)
    • ►  March (1)
  • ►  2022 (7)
    • ►  August (7)
  • ►  2015 (8)
    • ►  August (1)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ►  March (1)
    • ►  February (2)
  • ►  2014 (5)
    • ►  June (1)
    • ►  April (3)
    • ►  January (1)
  • ▼  2013 (30)
    • ►  December (3)
    • ►  November (3)
    • ►  August (4)
    • ►  July (1)
    • ►  June (4)
    • ►  May (1)
    • ►  April (5)
    • ►  March (2)
    • ►  February (4)
    • ▼  January (3)
      • How to find the Size of the Screen in C#.net
      • How to delete Duplicate Record From a Table in SQL...
      • How to Isert Data From Text File to SQL Server Table
  • ►  2012 (5)
    • ►  December (2)
    • ►  November (3)

About Me

niaz
View my complete profile
@niazstat. Simple theme. Powered by Blogger.