How to Delete Duplicate Rows from a table

25. June 2010

In this Example, i will tell you how to delete a duplicate rows from a table.

DELETE FROM [TABLE NAME] 
WHERE ID NOT IN (select MAX(ID) FROM [TABLE NAME] 
GROUP BY [DUPLICATE COLUMN NAME])


Author: Aamir Hasan     औथोर: आमिर हसन       أثر أمير حسن .

ALL, SQL Injection ,


Comments

Add comment


(Will show your Gravatar icon)

  Country flag

biuquote
  • Comment
  • Preview
Loading





User Name: Guest

Your Ip: 38.107.191.93
Time: