>
>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 Alb
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