>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