Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How do you select distinct rows that are similar but not identical
"colinlyse" <colinlyse_at_yahoo.com> a écrit dans le message news:
3fcdf1d3$0$214$45beb828_at_newscene.com...
> have a resultset as follows (its result of of a connect by, prior tree
query
> that shows me the hier. of substations) it is ordered by the Level desc.
>
> LEVEL TERMINAL_ID_SQ SUBSTATION TERMINAL_NAME
> 10 11664 TAS50
69KV1
> 8 11664 TAS50
69KV1
> 6 7782 TSR41 1
> 4 7782 TSR41 1
> 2 7500 DC315
4kV-1
>
>
> I want the following result set
>
> SUBSTATION TERMINAL_NAME
> TAS50 69KV1
> TSR41 1
> DC315 4kV-1
>
> note that is has to be in the order of the level but i don't want to see
same
> instance of substation eventhought it is at a different level (don't care
it
> it uses level 10 or 8 they are identical in station and terminal names)
Try the following :
select distinct SUBSTATION, TERMINAL_NAME
from
(
<subquery that gives the first resultset>
)
/
-- AlkosReceived on Wed Dec 03 2003 - 08:47:56 CST