DELETE DUPLICATE VALUES IN TABLE

Submit Code |

Search Codes |

Code Home |

DELETE TABLE WHERE EMPID IN(SELECT EMPID FROM EMPLOYEE GROUP BY EMPID 



HAVING COUNT(*)<1)

REGARDS

sriram

Found interesting? Add this to:

| More | Bookmark It

>> Write Response - Respond to this post and get points

More codes snippets
	DROP PRIMARY KEY CONSTRAINT IN SQL SERVER CREATE TABLE IN PRIMARY KEY CONSTRAINT... Data List with paging and Select Image on a data list Using jQuery Auto Image Scroller Read Resource File values in Javascript Read C# DateTime function in Javascript Convert a Color Image into Grascale How to get the path/directory for the current assembly? Paging in SQL Server Submit Code \| More ...

General Notice: If you find plagiarised (copied) contents on this page, please let us know the original source along with your correct email id (to communicate) for further action.

Copyright © DotNetFunda.Com. All Rights Reserved. Copying or mimicking the site design and layout is prohibited. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 5/23/2013 11:51:32 AM

DELETE DUPLICATE VALUES IN TABLE

More codes snippets