You Asked

How to print First Three records of table without using rownum and rowid?

and Chris said...

Pre-12c you can use the analytic function row_number():

select *
from   (
  select t.*, row_number() over (order by cols) rn
  from   t
)
where  rn <= 3;

12c onwards it gets even easier with the fetch first syntax:

select * 
from   t
order  by cols
fetch  first 3 rows only;

(2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

abhu, March 16, 2016 - 11:47 am UTC

I tried ur solution . Its working properly.

Jeff, March 16, 2016 - 6:04 pm UTC

It's a trick question - how do they define the "first" rows in a table"?

March 17, 2016 - 2:17 am UTC

fair point

Analytic SQL got you confused? Check out Connor McDonald's complete video course.