exclude record in same time frame

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • k01902
    New Member
    • Feb 2010
    • 1

    exclude record in same time frame

    The-Center-3004 23/11/2009 9:50 23/11/2009 9:51 SOP Status
    The-Center-3004 23/11/2009 9:52 23/11/2009 10:00 SOP Status
    The-Center-3004 23/11/2009 9:53 23/11/2009 10:00 Out of order
    The-Center-3004 04/12/2009 10:49 04/12/2009 10:52 SOP Status
    The-Center-3004 04/12/2009 10:52 04/12/2009 10:52 Network

    The-Center-3004 04/12/2009 10:55 04/12/2009 10:55 Out of order
    The-Center-3004 05/11/2009 9:45 05/11/2009 9:51 SOP Status
    The-Center-3004 05/11/2009 9:45 05/11/2009 9:51 Out of order

    The-Center-3004 25/11/2009 5:17 25/11/2009 5:31 Network
    The-Center-3004 25/11/2009 5:17 25/11/2009 5:31 Out of order

    The-Center-3004 25/11/2009 7:17 25/11/2009 7:17 Network

    i have one table select siteid,startdat etime,enddateti me,status i want only one record if the time period in between previous record for ur ref (in italic font ) i want only one record out of all records which are italic and bold
Working...