title: Remove duplicates in large amount mysql database by time different in xsecound
body: <p>I have looked at the other question with a similar topic, but it does not solve the issue I am currently having following table.</p>
  
  <pre><code>action_table(actionid,cookieid,intime,page)
  </code></pre>
  
  <p>I have data like follows</p>
  
  <pre><code>235470 ,994341855.1473047915, 2016-09-05 07:01:57, index.aspx
  235471, 994341855.1473047915,  2016-09-05 07:02:00, index.aspx
  235472, 994341855.1473047915,  2016-09-05 07:02:02, index.aspx
  235473, 994341855.1473047915,  2016-09-05 07:02:12, home.aspx
  235474, 994341855.1473047915,  2016-09-05 07:04:12, index.aspx
  </code></pre>
  
  <p>user can unlimited time of refresh his page its should be a duplicate like follows so only the auto increment (<code>actionid</code>) and the <code>intime</code>  only different so I just want get data like follows </p>
  
  <pre><code>235470 ,994341855.1473047915, 2016-09-05 07:01:57, index.aspx
  235473, 994341855.1473047915,  2016-09-05 07:02:12, home.aspx
  235474, 994341855.1473047915,  2016-09-05 07:04:12, index.aspx
  </code></pre>
  
  <p>avoid duplicate entry like cookie id and page is same and also if there is any page in between the same page then it should be a new entry.</p>
  
  <p>How is possible to select like that query? Is there is any grouping is available?
  Please help me</p>