title: How to delete all duplicate records from SQL Table?
body: <p>Hello I have table name <strong>FriendsData</strong> that contains duplicate records as shown below </p>
  
  <pre><code>fID UserID  FriendsID       IsSpecial      CreatedBy
  -----------------------------------------------------------------
  1   10         11            FALSE            1
  2   11          5            FALSE            1
  3   10         11            FALSE            1
  4    5         25            FALSE            1 
  5   10         11            FALSE            1
  6   12         11            FALSE            1
  7   11          5            FALSE            1
  8   10         11            FALSE            1
  9   12         11            FALSE            1
  </code></pre>
  
  <p>I want to remove duplicate combinations rows using MS SQL?<br>
  Remove latest duplicate records from MS SQL FriendsData table.
  here I attached image which highlights duplicate column combinations.</p>
  
  <p><img src="https://i.stack.imgur.com/GT4X2.png" alt="enter image description here"></p>
  
  <p>How I can removed all duplicate combinations from SQL table?</p>