Xref: alice comp.databases.oracle.server:70103 comp.databases.oracle.tools:33864
Path: alice!news-feed.fnsi.net!netnews.com!newsfeed.gamma.ru!Gamma.RU!demos!news1.relcom.ru!komitex.ru!news
From: "Igor Faershtein" <faershtein@usa.net>
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.tools,relcom.comp.dbms.oracle
Subject: Re: Oracle Queries/Paging
Date: Sat, 16 Oct 1999 14:24:26 +0400
Organization: Komitex (Komi News Server)
Lines: 20
Message-ID: <7u9nk5$8a1@komitex.komitex.ru>
References: <7u2fl3$15j$1@nnrp1.deja.com> <3805DABB.8F67015E@mpsb.moris.ru> <7u54nn$urt$1@nnrp1.deja.com> <380701FC.DDDDA8@mpsb.moris.ru> <3807028B.6DD45BAB@mpsb.moris.ru> <7u7as2$hbe$1@nnrp1.deja.com> <7u9lhv$7u7@komitex.komitex.ru>
X-Newsreader: Microsoft Outlook Express 5.00.2417.2000
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

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*/
 group by rownum, a.RN,a.ID,a.CODE
 having rownum >=5 and rownum <8

 /*order clause */

Igor