How can I remove duplicate rows from one SQL Server database table?
<p>I want to delete the duplicate entries from one table of database (SQL).
I don't understand how do I do this?</p>

<p>Please help me to write a query for this problem.</p>

<p><strong>For e.g.-</strong></p>

<pre><code>Name | mobileno | address

abc  | 99xxxx01 | India

abc  | 99xxxx01 | India

def  | 98xxxx02 | USA
</code></pre>