select name, group, max(salary) over (partition by group order by salary
desc) max_salary from test
"jared" <jared_at_hwai.com> wrote in message
news:1111003625.538628.181650_at_o13g2000cwo.googlegroups.com...
> This is probably easy and I'm missing it because I'm a little
> sleep-deprived this month, but:
>
> given the following table 'test':
>
> name group salary
> ----- ----------- ------
> unique medium cardinality
>
>
> How can I select the name(s) for each group that have the highest
> salary for that group?
>
Received on Tue May 10 2005 - 04:21:19 CDT
