How to remove Duplicated data in SQL Table?

Hi

I want to know, how to remove duplicated data in Sql Table using a SQL query? Im using SQL Management Studio Express Edition to connect to database.

Your help will be highly appreciated.

See this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1425992&SiteID=1

Or these articles:

Duplicates –Delete
http://www.sql-server-performance.com/rd_delete_duplicates.asp

Duplicates –Find
http://www.aspfaq.com/2431

Duplicates –How do I remove duplicates from a table?
http://databases.aspfaq.com/database/how-do-i-remove-duplicates-from-a-table.html

Duplicates –How to remove duplicate rows from a table in SQL Server
http://support.microsoft.com/?id=139444