ROWNUM

Hi,

I have a big problem with "ROWNUM" when i use it in a query like this : "SELECT [...] WHERE ROWNUM > xxx"

If xxx = 0, there is no problem. The query returns all the rows ! If xxx > 0, the query returns no row !!!! Why?

DB : Oracle 8.0.5 for Windows NT.

Thanks for your help.

Denis Muyldermans
denis.muyldermans_at_groupe-expert.com Received on Thu Mar 23 2000 - 09:17:55 CST