Eine Einführung in

SQL

Get the 11th to the 20th rows of the cia table - by population.

Oracle


Specific to Oracle
This seems very complicated, seemingly the rownum is calculated after the WHERE clause runs so WHERE rownum>1 always gives zero rows.