Technical Corner: Delete all duplicate Record from access database

Showing posts with label Delete all duplicate Record from access database. Show all posts

Monday, May 26, 2008

DELETE *FROM svprodtabWHERE itmno in(SELECT [Itmno]FROM svprodtabGROUP BY [Itmno]HAVING count(Itmno)>1ORDER BY [Itmno]);
www.svdeals.com