display 2nd last record using rownum???
Printable View
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);
[QUOTE=monika1985;29331]display 2nd last record using rownum???[/QUOTE]
are you assigning some task to our experts ?