Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicates in SQL statement

Re: Duplicates in SQL statement

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 22 Apr 2005 21:23:09 +0200
Message-ID: <kmji61pquofdl5lfln0vs04ie102n3i0ch@4ax.com>


On 22 Apr 2005 12:08:32 -0700, krallabandi_at_gmail.com wrote:

>This sql statement returns duplicate records. Please let me know what I
>have to change? I appreciate your help.

You could of course replace select by select distinct, but then it could also be your data, and we don't have any information about the tables you use in this statement, so no one really can't answer this.

--
Sybrand Bakker, Senior Oracle DBA
Received on Fri Apr 22 2005 - 14:23:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US