hello,

[monika1985]

display 2nd last record using rownum???

[krishnaindia2007]

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);

[debasisdas]

display 2nd last record using rownum???

are you assigning some task to our experts ?