Oracle > Selecting the first n rows with Oracle by row_number()

select name, price
  from (
    select name, price, row_number() over (order by price) r
      from items
  )
where r between 1 and 5;