Monday 16th of September 2019 10:22:23 PM
Our Services
Select Theme
Back
SET ROWCOUNT 1
DELETE yourtable
FROM yourtable a
WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.name = a.name AND b.id =
a.id) > 1
WHILE @@rowcount > 0
DELETE yourtable
FROM yourtable a
WHERE (SELECT COUNT(*) FROM yourtable b WHERE b.name = a.name AND b.id=
a.id) > 1
SET ROWCOUNT 0
 
     
     
Home | About Us | Products | Services |  Templates | Demo | Contact Us | Careers | Feedback | SiteMap
2005-2014 Logical Technologies. All Rights Reserved.