Hi,
In sql query what is the difference between rowid and rownum ?
As I know that :
rowid is the unique index number of every row of table maintaining by database automatically.
rownum is the sequential number of rows in the resultset object.
But my confusion is if I write query like below for extracting 1st row
select * from table_name where rownum = 1 Then it is working fine
But if I write query like below for extracting 3rd row
select * from table_name where rownum = 3 Then it is returning zero row.
for that i have to write query like below
select * from table_name where rowid in(
(select rowid from table_name where rownum <= 3)
minus
(select rowid from table_name where rownum < 3)
)
Can any one please clarify me.
Thanks & Regards
Bikash

[ June 03, 2004: Message edited by: Bikash Paul ]