Oracle "limit"

Hi,

Does anyone know Oracle's syntax for the MySQL's equivalent "limit" clause?

I've seen that the following SQL query works:

select column_name from schema_name.table_name where rownum<=20;

But it doesn't return anything if I use:

select column_name from schema_name.table_name where rownum<=20 and rownum>=10;

...or other combinations.

And I want to select from the row 10 to the row 20.

Thanks.

Octavian

__________
View the list's information and change your settings at http://www.freelists.org/list/programmingblind

Other related posts: