title: How to delete Duplicates in MySQL table
body: <p>I've given a client the following query to delete duplicate phone no. records in an MSSQL database, but now they need to also do it on MySQL, and they report that MySQL complains about the format of the query. I've included the setup of a test table with duplicates for my code sample, but the actual delete query is what counts.</p>
  
  <p>I'm asking this in ignorance and urgency, as I am still busy downloading and installing MySQL, and just maybe somebody can help in the mean time.</p>
  
  <pre><code> create table bkPhone
   (
       phoneNo nvarchar(20),
       firstName nvarchar(20),
       lastName nvarchar(20)
   )
   GO
  
   insert bkPhone values('0783313780','Brady','Kelly')
   insert bkPhone values('0845319792','Mark','Smith')
   insert bkPhone values('0834976958','Bill','Jones')
   insert bkPhone values('0845319792','Mark','Smith')
   insert bkPhone values('0828329792','Mickey','Mouse')
   insert bkPhone values('0834976958','Bill','Jones')
  
   alter table bkPhone add phoneId int identity
  
   delete from bkPhone
   where phoneId not in
   (
       select min(phoneId)
       from bkPhone
       group by phoneNo,firstName,lastName
       having  count(*) &gt;= 1
   )
  </code></pre>