Tag Archives: offset

I only want these first rows – 12c edition – Part 1

How many times have you tried to query just for the first few rows with a SQL statement like: SELECT id, brewery, city, state, country FROM barmaid.beers WHERE rownum <10 Results: In this first part of discussing Oracle’s new native SQL support for limiting rows, we are going to look at the FETCH and OFFSET […]