Hi all,

I have table with data inside;

no calving date
---- ------------

1 10-jan-2001
2 11-feb-2002
3 08-jan-2003




I'm looking for querry which will return

no calving date inter calving period in day
---- ------------ ---------------------------

1 10-jan-2001 0
2 11-jan-2002 366
3 10-jan-2003 365




here is example how should it be;


no calving date inter calving period in days
---- ------------ ---------------------------

1 10-jan-2001 0 first row it
should be ZERO
2 11-jan-2002 366 no of days between second
calving date and first calving date i.e no of days between 11-jan-2002
and 10-jan-2001
3 10-jan-2003 365 no of days between third
calving date and second calving date i.e no of days between 10-jan-2003
and 11-jan-2002


Thanks &Regards,
Harik

Oracle LazyDBA home page