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
