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

Difficulty to select distinct rows from view.

From: <andkovacs_at_yahoo.com>
Date: 7 Jun 2005 09:51:26 -0700
Message-ID: <1118163086.681162.23640@g44g2000cwa.googlegroups.com>


I have a view base on three columns( ID, historical_date, value) The view is built like this:
select * from hourly_data
Union
select * from daily_data
Union
select * from weekly_data;

I do the following select on this view:

select ID, historic_date, value from hist_data;

And it returns

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 ) ? Received on Tue Jun 07 2005 - 11:51:26 CDT

Original text of this message

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