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

Home -> Community -> Usenet -> c.d.o.misc -> Re: DISTINCTROW

Re: DISTINCTROW

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 12 Oct 1999 08:50:09 -0400
Message-ID: <bS4DOLNVH6EcSgfPiR=rJZsnRVyB@4ax.com>


A copy of this was sent to gordyefrank_at_my-deja.com (if that email address didn't require changing) On Mon, 11 Oct 1999 21:46:36 GMT, you wrote:

>I am porting Access SQL code to Oracle. I can't use the DISTINCTROW
>command in my SELECT query in Oracle without generating an error. How
>can one use DISTINCTROW in Oracle or is this not available? I am
>pulling information from multiple tables and just DISTINCT won't work.
>

can you tell us how distinctrow differs from distinct? what does distinctrow do?

>
>Thanks In Advance,
>
>Gordy Frank
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Oct 12 1999 - 07:50:09 CDT

Original text of this message

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