A question on SQL query

[Sanat Padhy]

Is it possible to write a query for the following?

Say I have a table "Account" as below
ACCTNO -- FUNDID -- UNITS
64746-------200----------6
64746-------200----------7
64746-------201----------4
64746-------201----------6

Now I want to select such that it returns the following rows
ACCTNO -- FUNDID -- UNITS
64746-------200----------7
64746-------201----------6
In other words the funds with maximum units.

Thanks in advance.
Sanat

[Jeanne Boyarsky]

Sanat,
Yes. Take a look at the group by operator. You can use the max() function on one column if you list all the other columns in the group by clause.

Psuedocode:

select colsToGroup, max(colToCheck)
from table
group by colsToGroup