There are lot of ways of doing this. We can be
more specific, if you can provide us with the create table
scripts (DDL), sample data and the output you want.

Also have a peek at http://www.databasejournal.com/features/mssql/article.php/1438651

John
www.ideo.com

-----Original Message-----
From: Jaimie Freitas [mailto:jaimie.[Email Address Removed] January 30, 2003 1:27 AM
To: LazyDBA.com Discussion
Subject: Help for a beginner


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

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page