You want to select distinct cust_id or remove duplicates?

Select reg_nbr, cust_id from table_name where cust_id in (select distinct
cust_id from table_name)


-----Original Message-----
From: Chandra Guptan Bose
[mailto:mssqldba-ezmlmshield-x81330436.[Email address protected]
Sent: Friday, October 28, 2005 5:52 PM
To: LazyDBA Discussion
Subject: How to Select the Unique records

Hi all,



I have duplicates in one table where the required field is not PK bu i

want the unique records in that



reg_nbr cust_id

--------- ----------

100 sd

200 er

300 sd



i want unique records on cust_id as it goes as a PK in the target table.



Chandra Guptan Bose,

Software Engineer,

Charles Schwab ,

Datawarehousing Center,

iGATE Global Solutions

Bangalore



Ph No : +91-80-51040000 Extn: 5382

Mobile : +91-98863-97793

Web : http://chandraguptan.250free.com

<http://chandraguptan.250free.com/>

Email : [Email address protected] <mailto:[Email address protected]

Where There's A Will There's A Way...





_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



Information transmitted by this EMAIL is proprietary to iGATE Group of
Companies and is intended for use only by the individual

or entity to whom it is addressed and may contain information that is
privileged, confidential, or exempt from disclosure under

applicable law. If you are not the intended recipient of this EMAIL
immediately notify the sender at iGATE or [Email address protected]

and delete this EMAIL including any attachments

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



MS Sql Server LazyDBA home page