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

Home -> Community -> Usenet -> c.d.o.tools -> select distinct does not work on Oracle 8i

select distinct does not work on Oracle 8i

From: Bernd Rosenau <brosenau_at_gss-online.de>
Date: Thu, 12 Oct 2000 14:42:02 +0100
Message-ID: <jsfbus8nmfa2pa7lmgmt2fv8au8kpg4vcd@4ax.com>

Hello,

our application is programmed in VB 6 and connects to an Oracle database
using ADO. The following statement submitted from the client works ok if the backend is Oracle 8.0.5 but it is giving non-distinct results when the backend is Oracle 8i.

SELECT DISTINCT Bereich FROM GenericTable

What can i do ?

Many thanks in advance for your help,

Regards, Bernd Received on Thu Oct 12 2000 - 08:42:02 CDT

Original text of this message

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