title: More than 2 or 3 identical records : Delete Mysql
body: <p>I have a mysql table where I have more than 2 or 3 identical records.
  In a table,
  Joining on  column1,column2,column3 and column4 have identical values then those records are considered duplicate.
  I dont care about the rest of the columns in the table but if the combination of above 4 columns are identical i want to delete all records for min(Id) keeping one single record of max (id)</p>
  
  <pre><code>  id,      site,      sector,       para1,       para2
  '652',    'LCUE1015', '1',          '2275',       '0'
  '166994', 'LCUE1015', '1',          '2275',       '0'
  '5343',   'LCUE1015', '1',          '2275',       '0'
  '166003', 'LCUE1015', '1',          '2275',       '0'
  '76351',  'LCUE1015', '1',          '2275',       '0'
  '77342',  'LCUE1015', '1',          '2275',       '0'
  </code></pre>