Re: Oracle Queries/Paging

[Quoted] In this example ORDER BY clause works _AFTER_ selecting by rownum, that made invalid sorting.

Igor Faershtein wrote:
>
> 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
Received on Mon Oct 18 1999 - 13:04:22 CEST