How to select last row of table

[admin]

sql> select count(*) from My_TAble;

sql>SELECT * FROM MY_TABLE WHERE ROWID
=(SELECT ROWID FROM mY_TABLE
WHERE ROWNUM <=&ROWNUM
MINUS
SELECT ROWID FROM mY_TABLE
WHERE ROWNUM < &ROWNUM)
for last row pass return value of Count(*) to rownum;
for more than one rows (i.e 2 to 5)

SELECT * FROM MY_TABLE WHERE ROWID
IN (SELECT ROWID FROM mY_TABLE
WHERE ROWNUM <=5
MINUS
SELECT ROWID FROM mY_TABLE
WHERE ROWNUM < 2)
divyanand