first X number of career years

[Matt Bandi]

Does anyone know a command I could use to query the first X number of career seasons for all players? For example, let's say I wanted to use Baseball Databank database to find the all-time leaders in home runs during a player's first three years in the majors, or something like that.

Thanks for any suggestions. 

[Daniel Hirsch]

Matt,

I would try this..

SELECT Batting.playerID, SUM(HR) AS HR FROM Batting LEFT JOIN (SELECT playerID, MIN(yearID) AS first FROM Batting GROUP BY playerID) AS z ON (Batting.playerID = z.playerID) WHERE Batting.yearID < z.first + 10 GROUP BY Batting.playerID ORDER BY HR DESC

Dan Hirsch

thebaseballgauge.com

seamheads.com

[Matt Bandi]

Worked perfectly. Thanks so much for your help.