Duration

[prabhu_rathnam]

Hi All,

Question:

i have mater table

job_name ,starttime, end time

ods, c, 01:01:40

ods, 01:04:25, 01:05:25

edw, 01:03:04, 01:03:25

edw, 01:05:45, 01:06:20

......

i need my resport as

edw start_time - ods start_time (01:05:45 - 01:05:45).

Can some one please help me