Comand RowNum

[Carmem]

Helo

I need to use the RowNum command in select thus RowNum>=10 and
RowNum>=5

I I obtain?

Please me they help
I´m from Brazil,

I write and I read very badly English

[sonaliak]

I don't get your question, but see if this is what you want.
Select * from test
where rownum>9.

OR
If you want the rows between 5 and 10 try this.
Select * from test
where rownum>9
MINUS
Select * from test
where rownum>4

Sonali

[chrisrlong]

I see someone else is proposing the MINUS solution for the 'sliding window' issue.

Please read the "Resultset Paging & Performance increase using ROWNUM " thread in the Oracle Administration forum for a better solution (and a very good discussion of it all ;) )

- Chris