HI All,
I need a query to find out how many consecutive numbers at a time.
for example
from below there are 3 p consecutive then W then again start P , Here number of P's is 4 so it will return 4 means highest number of consecutive number will return.
Can anybody helps me in this regards.
Table name is attendance_details