Re: selecting rows for only column
From: Shamil Valeev <valeevsh_at_mail.ru>
Date: Fri, 19 Apr 2002 11:54:47 +0700
Message-ID: <a9o7su$soo$1_at_news.nsk.su>
Date: Fri, 19 Apr 2002 11:54:47 +0700
Message-ID: <a9o7su$soo$1_at_news.nsk.su>
Hi Marianna,
This command looks little bit perplexed but it works: select xxx.CA, xxx.CB, (select CC from (select * from x order by 1,2,3) xxo where xxo.ca=xxx.ca and xxo.CB=xxx.CB and rownum<2) CB
from (select xx.ca, (select CB from (select * from x order by 1,2,3) xo where xo.ca=xx.ca and rownum<2) CB
from (select DISTINCT CA from x) xx) xxx Received on Fri Apr 19 2002 - 06:54:47 CEST