how to second row, third row ....
904918Dec 13 2011 — edited Dec 15 2011below query give first row
SELECT ROWNUM,EMPNO,ENAME,SAL FROM EMP
WHERE ROWNUM=1
how to get other i mean second row third row
SELECT ROWNUM,EMPNO,ENAME,SAL FROM EMP
WHERE ROWNUM=2
SELECT ROWNUM,EMPNO,ENAME,SAL FROM EMP
WHERE ROWNUM=3
i want to create view in which i store values of row for exapmle
sal of second row
sal of third row