morethan 3 consecutive rows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 31

Thread: morethan 3 consecutive rows

Threaded View

  1. #1
    Join Date
    Oct 2002
    Posts
    25

    morethan 3 consecutive rows

    We have to find and flag the occurance of values >=3 if it happens more than 3 consecutive cycles/rows.It could happen within same subtype or different subtypes

    example:-

    time subtype value flag
    7:00 a 2
    7:00 a 0
    7:00 a 5
    7:03 a 3
    7:03 a 2
    7:03 a 1
    7:06 a 3 Y
    7:06 a 3 Y
    7:06 a 4 Y
    7:09 b 5 Y
    7:09 b 2
    7:09 b 1
    Last edited by rajan1; 03-31-2006 at 03:38 PM.

Posting Permissions

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


Click Here to Expand Forum to Full Width