Hi,

I need a sql query that removes duplicate accountno from the contact1 table.

Thanks for all your help in advance

Jaimie

The contents of this e-mail are strictly confidential and are intended only
for the addressee named above. This e-mail may contain confidential or
privileged information. If you are not the intended recipient of this
message please notify the sender immediately. The contents of this e-mail
must not be disclosed to any other person or copies taken. Please note that
any views expressed in this e-mail may be those of the originator and do not
necessarily reflect those of this organisation. Internet e-mail is not a
secure communications medium. Please note this lack of security when
responding by e-mail. Accordingly we give no warranties or assurances about
the security and content of this e-mail and its attachments. Neither Thermo
Electron Corporation nor the sender accepts any responsibility or liability
for viruses and it is your responsibility to scan the e-mail and
attachments. Any liability arising from any third party acting on any
information contained in this e-mail is hereby excluded. (c) Thermo
Electron Corporation www.thermo.com
MS Sql Server LazyDBA home page