http://www.programmersheaven.com/feed/User/334239/RSS.aspx Events at Programmer's Heaven related to the user sabeerpasha. en Copyright 2013 Programmers Heaven Wed, 19 Jun 2013 10:25:28 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/mb/internet/308689/386167/ReadMessage.aspx#386167 <p>Posted a '<a href="http://www.programmersheaven.com/mb/internet/308689/386167/ReadMessage.aspx#386167">reply</a> on the <a href="http://www.programmersheaven.com/mb/internet/Board.aspx">Internet Development</a> forum.</p>U can find and delete the Duplicate files<br /> <br /> delete from test a<br /> where rowid &lt;&gt; ( select max(rowid)<br /> from test b<br /> where a.sno = b.sno<br /> and a.sname = b.sname )<br /> <br /> This querry will find duplicate rows and delete those.<br /> <br /> Regards,<br /> Pasha<br /> http://www.programmersheaven.com/mb/internet/308689/386167/ReadMessage.aspx#386167 Sat, 21 Feb 2009 23:58:45 -0700