QUERY HELP

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Tue, 26 Jun 2001 04:51:53 -0700
Message-ID: <F001.00337EDA.20010626050038@fatcity.com>

Dear Guru's,

How can i refer the previous record detail(s), when oracle fetchs the current row details?.

sql> SELECT rownum rnum, empno eno, ename FROM EMP;

RNUM    ENO     ENAME

---

1       7369    SMITH
2       7499    ALLEN
3       7521    WARD
4       7566    JONES
7       7782    CLARK
8       7788    SCOTT

10      7844    TURNER In the above, can i able to put * mark in record 7 and 10, since before these two records, some records are missing.

Is this possible to do this by query. I need this in reports.

Basically my question is,
How can i refer the previous row detail(s), when oracle fetchs the current row details?.

Thanks in adv.

REgards,
Nirmal. Received on Tue Jun 26 2001 - 06:51:53 CDT