How to know the days or months or years between two employees in emp table.

jbabu

 Profile Answers by jbabu Questions by jbabu

• Dec 10th, 2007

Select hiredate,lead(hiredate,1) over(order by hiredate) next_months, round(months_between(lead(hiredate,1) over(order by hiredate),hiredate),3) months from emp;

Answer Question  Select Best Answer