Re: How To Find Baseball Consecutive Hit Streak With A Select Statement

Greg Teets wrote:
> I've never known how to do this in a SELECT statement and I only think
> about this when I'm watching a baseball game. Well, I've been
> watching the baseball playoffs, so here we go:
>
> A table has columns for player name, game number, and the number of
> hits that player had in that game. Can I find out which player had
> the longest streak of games with a hit in each game.
>
> Obviously a GROUP BY player_name, but how can I write a clause to
> calculate the number of consecutive games that a player had hits
> greater than 0? Note that a player may not have played in every game
> during a season.
>
> Thanks.
>

[Quoted] Sounds like homework... :)

Load them into an array in ascending player,game order. Then just loop through using n and (n+1) logic keeping track of the player and whether or not the game counter should increment or restart counting within each player.

What happens if a player never gets a hit in any game?

Cliff Received on Sun Oct 19 2003 - 13:01:42 CEST