island and gap , how to find the long unbeaten record
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
Subject
Written By
Posted
island and gap , how to find the long unbeaten record
September 08, 2017 02:27AM
September 08, 2017 09:34AM
Sorry, you can't reply to this topic. It has been closed.
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.