This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
Monday, May 26, 2008
Delete all duplicate Record from access database
DELETE *FROM svprodtabWHERE itmno in(SELECT [Itmno]FROM svprodtabGROUP BY [Itmno]HAVING count(Itmno)>1ORDER BY [Itmno]); www.svdeals.com
No comments:
Post a Comment