Thanks Cetin!

>>Hi all, I have a table with the following fields: Family, name, age and level. In this table a family can have several members and I need a SQL statement that gets me the older member of each family order by level. For example:
>>
>>

>>Family  Name      Age    Level
>>--------------------------------
>>01      xxxxxxxx   15      1
>>01      xxxxxxxx   13      1
>>01      xxxxxxxx   17      2
>>02      xxxxxxxx   12      1
>>02      xxxxxxxx   15      1
>>02      xxxxxxxx   13      1
>>03      xxxxxxxx   13      1
>>03      xxxxxxxx   18      2
>>03      xxxxxxxx   12      1
>>
>>

>>
>>The result should be:
>>
>>

>>Family  Name      Age    Level
>>--------------------------------
>>01      xxxxxxxx   15      1
>>02      xxxxxxxx   15      1
>>03      xxxxxxxx   13      1
>>01      xxxxxxxx   17      2
>>03      xxxxxxxx   18      2
>>
>>

>>
>>Any help is greatly appreciated!
>>
>>Enmanuel
>
>

>select * from myTable A ;
> where Age = ;
> (select max(age) from myTable B ;
>     where a.Family = b.Family and a.Level = b.Level) ;
>     order by Level,Family
>

Cetin