<div>
check whether this helps<br />
<br />
<a href="http://database.ittoolbox.com/groups/technical-functional/db2-l/db2-deleting-dupliate-rows-535440#" rel="ugc">http://database.ittoolbox.com/groups/technical-functional/db2-l/db2-deleting-dupliate-rows-535440#</a><br />

</div>


check whether this helps

http://database.ittoolbox.com/groups/technical-functional/db2-l/db2-deleting-dupliate-rows-535440# [http://database.ittoolbox.com/groups/technical-functional/db2-l/db2-deleting-dupliate-rows-535440#]


<div>
Microsoft have got a comprehensive article here:<br />
<a href="http://support.microsoft.com/kb/139444" rel="ugc">http://support.microsoft.com/kb/139444</a>
</div>


Microsoft have got a comprehensive article here:
http://support.microsoft.com/kb/139444 [http://support.microsoft.com/kb/139444]

<div>
<div class="content wysiwyg-content">
hi there ,<br />
how can i delete duplicate rows<br />
dmt_campaign_id<br />
<br />
1008<br />
1008<br />
1008<br />
1008<br />
1007<br />
1006<br />
1005<br />
1005<br />
1008<br />
1002<br />
1006<br />
<br />
i want it to be<br />
<br />
1008<br />
1007<br />
1006<br />
1005<br />
1002
</div>
</div>


hi there ,
how can i delete duplicate rows
dmt_campaign_id

1008
1008
1008
1008
1007
1006
1005
1005
1008
1002
1006

i want it to be

1008
1007
1006
1005
1002

delete duplicate rows

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.