Delete or remove duplicate rows from SQL Server table using TSQL

In most of the SQL Server forum i found that they are asking to delete or eliminate duplicate rows form their table. The most common reasons are import twice, Front-end application save same data for each refresh etc. Here i want to share with you how we can remove duplicate rows data from a database table. One thing keep in mind that for different scenario you need different TSQL query or script