SQL Query

From: jared <jared_at_hwai.com>
Date: 16 Mar 2005 12:07:05 -0800
Message-ID: <1111003625.538628.181650@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 Wed Mar 16 2005 - 14:07:05 CST