I'm trying to do a count of which GMCODE has the longest consecutive values equal to 'T' in the SETTING column and then list out all the GMCODES in descending order (from most to least). So here is some data for the sake of explaining what I want a little bit better...
Oracle : 10.2g
KEY
----------------------------------------
GMCODE - code of the game
SETTING - boolean value of true or false
EVNT_ID - id specific to an event that happened on during a specific sequence (SEQ)
SEQ - unique value which is never duplicated and which states the order in which everything occurs (kind of like a timestamp)
------------------------------------------
GMCODE SETTING EVNT_ID SEQ
486609 F 1 150
486609 F 4 151
486609 T 1 152
486609 T 2 153
486609 T 4 154
486609 T 10 155
486609 F 1 156
253048 T 6 201
253048 F 4 202
253048 T 2 203
253048 F 2 204
253048 F 7 205
486778 F 4 245
486778 T 4 246
486778 T 1 247
486778 F 4 248
So what i would want in the output would be
GAMECODE COUNT(SETTING)
486609 4
486778 2
253048 1
So to explain in a little more detail, from SEQ 152-155 the SETTING is equal to 'T' (SEQ 156 has a SETTING of 'F so we end the count there), so in turn I get a cout of 4 for gamecode 486609
Edited by: user652714 on Dec 9, 2009 8:11 AM