Comparing Max Value with Second Highest Value Among Players?

Tech-Archive recommends: Fix windows errors by optimizing your registry

I want to do a query in which, among all baseball players who've had 10 or
more seasons of 500 or more at bats, I compare each player's maximum home
run season with their second highest home run season, to see which players
have the greatest "outlier" seasons (i.e., the greatest difference between
their highest HR season and their second highest HR season).

With a prep query, I've whittled my total DB down to the list of 133 players
who've had 10 or more 500+ at bat seasons. How can I now extract (or
excise) the maximum home run season for each player from this list, and then
find the maximum home run season for each player's remaining season?

I think if I can find out how to do that, I can take the query home. Any
ideas?

Thank you.

Chuck


.

Relevant Pages

  • Re: Checking if a set exists already -- non-normalized to normalized
    ... > Pierre Mullin submitted the following query to carry out the Todd ... Assume we have a table that tells us which players are on ... REFERENCES Players ... ON UPDATE CASCADE, ...
    (microsoft.public.sqlserver.programming)
  • Show all from tables in my junction...
    ... The db needs to manage a list of all active players ... So my query shows the junction and other tables, ... The junction query properly shows when I enter a name and date ... FROM SDates RIGHT JOIN (Roster LEFT JOIN RSJct ON Roster.STID = RSJct.StID) ...
    (microsoft.public.access.tablesdbdesign)
  • Re: select team members
    ... A query like the following will show you everyone that played on a specific date. ... FROM Players Inner Join GamePlayers ... -- Select GameDate field and enter the date in the criteria ... building the query you have suggested thanks again dennis ...
    (microsoft.public.access.gettingstarted)
  • Re: Searching calculated fields
    ... I'm assuming that you are not saving the EndOfBan date... ... Just do the calculations within the query. ... field is a calculated field - 1 day added to the DateofMatch field. ... I need to run a query to find all ineligible players for forthcoming ...
    (microsoft.public.access.forms)
  • RE: Real SQL scripting quandry linking data to 2 values on the same ro
    ... I think what you are trying to do is a double join to the teams (Players) ... To do this graphically in Access, add the TEAMS table to your query TWICE. ... Then draw a relationship between the HOMETEAMID to one and the AWAYTEAMID to ... > select HOMEPLAYERID, HOMEPLAYERGOAL, HOMEPLAYERASSIST, HOMEPLAYERRATING, ...
    (microsoft.public.inetserver.asp.db)