Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Difficulty to select distinct rows from view.
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