PL/SQL ROWNUM keyword and equality (=)

Question

I am new in PL/SQL and I am trying the ROWNUM keyword.

If I query this:

SELECT *
FROM my_table
WHERE ROWNUM <= 1

I am getting a result. Even in this case:

SELECT *
FROM my_table
WHERE ROWNUM = 1

But if I try

SELECT *
FROM my_table
WHERE ROWNUM = 2

I get an empty result..

But the table my_tablehas more than one tuple.

Can you help me?

Thank you!

http://stackoverflow.com/a/30321788/3989608 I have covered most of the things about ROWNUM in this answer. — Lalit Kumar B, May 21 '15 at 14:08

score 1 · Answer 1 · answered May 21 '15 at 14:13

1

ROWNUM is a psuedo column that has a value AFTER the result set is returned. Thus you can use where rownum < 2 but you can't select where ROWNUM equals a value because it does not have a value to compare to yet.

answered May 21 '15 at 14:13

Gary_W

9,933
1
22
40

PL/SQL ROWNUM keyword and equality (=)

1 Answers1