title: Remove duplicate rows in MySQL
body: <p>I have a table with the following fields:</p>
  
  <pre><code>id (Unique)
  url (Unique)
  title
  company
  site_id
  </code></pre>
  
  <p>Now, I need  to remove rows having same <code>title, company and site_id</code>. One way to do it will be using the following SQL along with a script (<strong><code>PHP</code></strong>):</p>
  
  <pre><code>SELECT title, site_id, location, id, count( * ) 
  FROM jobs
  GROUP BY site_id, company, title, location
  HAVING count( * ) &gt;1
  </code></pre>
  
  <p>After running this query, I can remove duplicates using a server side script.</p>
  
  <p>But, I want to know if this can be done only using SQL query.</p>