Re: Oracle Queries/Paging
From: Igor Faershtein <faershtein_at_usa.net>
Date: Sat, 16 Oct 1999 14:24:26 +0400
Message-ID: <7u9nk5$8a1_at_komitex.komitex.ru>
Date: Sat, 16 Oct 1999 14:24:26 +0400
Message-ID: <7u9nk5$8a1_at_komitex.komitex.ru>
[Quoted] I'm sorry, If you need to order first you can try the next way
select rownum , A.*
from
( select rownum rn, id,code from komioil.prim3
/*where clause*/
group by code,id, rownum /* ordering by code first, id next and the last
by rownum */
/*having clause */ ) A
/*****************/
/* where clause*/
[Quoted] group by rownum, a.RN,a.ID,a.CODE
[Quoted] [Quoted] having rownum >=5 and rownum <8
/*order clause */
Igor Received on Sat Oct 16 1999 - 12:24:26 CEST