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
In article <bqkt2s$132_at_news.rd.francetelecom.fr>, "Alkos" <azerty_at_nospam.org> wrote:
>
>
>Try the following :
>select distinct SUBSTATION, TERMINAL_NAME
>from
>(
><subquery that gives the first resultset>
>)
>/
>
doesn't work i need it to be ordered by level number note in the example that
they are in a certain order. When i do the distinct and try to order on level
i get an error message because the order by can not see the level, if i don't
use the order by then there is no guanrrentee that i an getting them in an
ordered fashion and in fact they come out in different orders. Basically i
want them ordered by level without just the distinct combinations
Received on Wed Dec 03 2003 - 09:43:16 CST