Apply the DISTINCT or UNIQUE function on the desired column while selecting. And if you want to restrict the entries in that column to uniques only then you have to create either the primary or unique key at the least on such a column or column list.
Gurmohan
www.onlymath.com - The place to learn and teach math.
-----Original Message-----
From: Chandra Guptan Bose
[mailto:oracledba-ezmlmshield-x79494709.[Email address protected]
Sent: Friday, October 28, 2005 11:52 AM
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
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page