Le 2012-06-06 à 22:20, Ken Tanzer a écrit :
>
> I can currently test whether someone has at least a specified number of consecutive absences with the query below, but it would be better to get the actual number.
>
> As a second question, what about getting the number of consecutive records for a set of values? (e.g., attendance_code IN ('ATTENDED','EXCUSED')
>
> Any ideas or suggestions? Thanks.
This is similar to the islands and gaps problem. Search for that on StackOverflow and you'll get it.
Bye!
François