select rownum,emp.* from emp
minus
select rownum,emp.* from emp where rownum<=(select (count(*)-3) from emp);
This will fetch the exact last 3 rows from emp table. If we include rownum as a...
Type: Posts; User: gksharma; Keyword(s):
select rownum,emp.* from emp
minus
select rownum,emp.* from emp where rownum<=(select (count(*)-3) from emp);
This will fetch the exact last 3 rows from emp table. If we include rownum as a...