How to delete duplicate rows in SQL Server? code example

Example 1: delete all content in table mysql

TRUNCATE tablename

Example 2: how to delete all duplicate items in mysql

DELETE FROM FriendsData WHERE fID 
       NOT IN ( SELECT fID FROM FriendsData 
                   GROUP BY UserID, FriendsUserID, IsSpecial, CreatedBy)