DELETE FROM table WHERE col1 IN (
SELECT id FROM table GROUP BY id HAVING ( COUNT(col1) > 1 )
)
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
-
▼
2014
(28)
-
▼
June
(9)
- Delete Duplicates Row in SQL SERVER
- Shatrughana Kumar Gupta: DateTime Formating Using ...
- DateTime Formating Using VB.NET
- Date Time Format of date
- Remove Duplicates from String
- Alphabetical Sorting Of any String Using vb.net
- Add Images in Listbox and copy from one directory ...
- Stop Sorting In Data Grid View using vb.net
- How to count files in Specific Folder using vb.net
-
▼
June
(9)
No comments:
Post a Comment