DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 31

Thread: morethan 3 consecutive rows

Threaded View

  1. 05-10-2006, 08:52 PM #26
    rajan1
    rajan1 is offline Junior Member
    Join Date
    Oct 2002
    Posts
    25
    Hi all,

    I was bouncing back and forth with the client to confirm on the requirement. As a result i modified the requirement please find the modified requirement attached. I am trying my best to clearly define the requirement to our experts here.

    1. Sort is by id and testdate
    2. Select all the rows where the difference between (testdate column) current row and the lead row or the next row is 3 minutes.

    I don't know how to proceed with consecutive times. Experts please help.

    Thanks,
    Rajan
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width