Re: hi, guys, please help me with this problem.

> > > > I have a problem with php and oracle. > > so far I still think this a defect of php. > > you know, this is a dataset in asp which we can use page or something, > > let the actually records we got just were limited to 1 page. > > but php seems has no such fuction. > > so i tried everything I can do to make i can get the same result with > > php, so far no luck. > > > > anybody can make php only get the 20 to 40 records from this sql > > statement? > > > > select * from table1 where a=b order by c > > > > Try > > select * from (select * from table1 where a=b order by c) where > rownum<40 > minus > select * from (select * from table1 where a=b order by c) where > rownum<20 > > > You'll need the subqueries to make shure the ROWNUM condition is applied > after sorting the rows. > It is also important which version of Oracle You use, because AFAIK versions before 8i doesn't support order clause in subqueries -- -------------------------------------------------------------------.------------ Remigiusz Sokolowski e-mail: rems@wp.pl / \ -----------------------------------------------------------------`---'----------