display 2nd last record using rownum???
display 2nd last record using rownum???
The following query displays 2nd last record using rownum
select * from emp
where rownum <= (select count(*)-1 from emp)
minus
select * from emp
where rownum < (select count(*) -1 from emp);