Oracle "limit"

  • From: Octavian Râşniţă <orasnita@xxxxxxxxx>
  • To: <programmingblind@xxxxxxxxxxxxx>
  • Date: Sat, 11 Apr 2009 18:17:22 +0300

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: