Re: SQL Query

From: Tomislav Kokoska <tkokoska_at_varteks.com>
Date: Tue, 10 May 2005 11:21:19 +0200
Message-ID: <d5pufn$e57$1_at_ss405.t-com.hr>


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 - 11:21:19 CEST

Original text of this message