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