MySQL Forums
Forum List  »  Newbie

island and gap , how to find the long unbeaten record
Posted by: Thembinkosi Fumba
Date: September 08, 2017 02:27AM

I have a table called riders with riders information in it, the structure is as follows:

id |time_of_ride |rider |Results
1 |08:12:16 |Gavin | Wins
2 |08:12:31 |Gavin | Wins
3 |08:12:40 |Louis | Loose
4 |09:12:31 |Gavin | Wins
5 |10:12:31 |Gavin | Wins
6 |10:12:31 |Gavin | Wins

I would like to find out for each rider what their longest unbroken run of wins was. such that the results could be like as follows.

Rider Wins
Gavin 3

Options: ReplyQuote


Subject
Written By
Posted
island and gap , how to find the long unbeaten record
September 08, 2017 02:27AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.