Sample table data: +---------+---------------+------------+-----------+----------+ | TitleID | Artist | Song | Player | NumPlays | +---------+---------------+------------+-----------+----------+ | 12345 | The foo bars | some song | player #1 | 90 | | 12345 | The foo bars | some song | player #2 | 465 | | 12345 | The foo bars | some song | player #3 | 741 | | 12346 | The bar foos | song song | player #1 | 23 | | 12346 | The bar foos | song song | player #2 | 345 | +---------+---------------+------------+-----------+----------+ Trying to figure out a query that will get me a record set like: +---------+---------------+------------+-----------+----------+ | TitleID | Artist | Song | Player | NumPlays | +---------+---------------+------------+-----------+----------+ | 12345 | The foo bars | some song | player #3 | 741 | | 12346 | The bar foos | song song | player #2 | 345 | +---------+---------------+------------+-----------+----------+ (The name of the player with the highest number of plays for each title.)