Hi Everyone,
How to determine the date difference between the current record and the next record?
For example, for every employee in DEPTNO 10, I want to determine the number of days between the day they were hired and the day the next employee was hired.
Below is a sample of employees in dept no 10:
DEPTNO ENAME HIREDATE
------ ------ -----------
10 CLARK 09-JUN-1981
10 KING 17-NOV-1981
10 MILLER 23-JAN-1982
I am using oracle9i, Please anybody suggest how to accomplish it with a brief explanation.
Any help is greatly appreciated.
Thanks in advance
How to determine the date difference between the current record and the next record?
For example, for every employee in DEPTNO 10, I want to determine the number of days between the day they were hired and the day the next employee was hired.
Below is a sample of employees in dept no 10:
DEPTNO ENAME HIREDATE
------ ------ -----------
10 CLARK 09-JUN-1981
10 KING 17-NOV-1981
10 MILLER 23-JAN-1982
I am using oracle9i, Please anybody suggest how to accomplish it with a brief explanation.
Any help is greatly appreciated.
Thanks in advance