rowNum()

rowNum() function always give the no of records fetched from the table but not the a row number in the table

Example :
select * from table where rowNum() =10;
above query will not return any thing