Re: Question and suggestion regarding rownum

From: Lakshmi Jagarlapudi <jlnarayana_at_comcast.net>
Date: Thu, 13 Nov 2003 20:59:32 GMT
Message-ID: <UgSsb.143292$ao4.458324@attbi_s51>

Maybe u can do something at the frontend level, but i think this sql should work...

select * from                                          -- wrapper query.

(
select rownum mynum,empno,sal from emp -- actual query )
where mynum between 45 and 55

let me know if this is what u want.

<ketansweta_at_sbcglobal.net> wrote in message news:THFsb.30024$FD7.22223_at_newssvr27.news.prodigy.com...
> Hi! Folks
>
> I am sure many of you have come across this problem which I am facing and
> hope to have some suggestions.
> We have an web application with tones of where clauses and group by but
> eventually the result set could be any where
> from 1 to 10000. Now the web page would display only 1 to 10 items after
> which if you would click on next it would show
> from 11 to 20 - till here it is some what do able - the problem lies when
> the user click on directly 45th page which should show records
> from 2000 onwards. I was thinking of using the rownum function .. remember
> this is a select from a 500K table - .
>
> Any folks who have a better idea or suggestion would be great ful.
>
> Thanks
> Ketan
>
>
Received on Thu Nov 13 2003 - 14:59:32 CST