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: Difficulty to select distinct rows from view.

Re: Difficulty to select distinct rows from view.

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 07 Jun 2005 19:20:15 +0200
Message-ID: <jplba1lvca3bulitvl4mvhibafh2okukob@4ax.com> 





On 7 Jun 2005 09:51:26 -0700, andkovacs_at_yahoo.com wrote:



>10, 2005/05/04, 10.56

>10, 2005/05/04, 10.53

>

>I only want the first row occur in the result set. Is there a way to do

>this ?

>How can I use DISTINCT option on columns (ID and historical_date ) ?




The rows you show are different, aren't they. DISTINCT is not going to
help.



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Jun 07 2005 - 12:20:15 CDT












Original text of this message













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