How do I do a single query to group a table by one column & then get the row of say the highest of each group ? Data is like so : Album, City, Plays, Date Britney, NYC, 103, 1-10 Britney, SF, 101, 1-10 Eminem, NYC, 100, 1-11 Eminem, SF, 102, 1-11 So I want to GROUP BY Album, then get the row with the highest # of Plays to get this result : Album, City, Plays, Date Britney, NYC, 103, 1-10 Eminem, SF, 102, 1-11 When I use a GROUP BY I keep getting arbitrary album records instead of the row I want ( highest plays). I've tried various combos of GROUP BY & HAVING but am stumped. thanks, - Sam. --------------------------------- Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
