>>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 >> >>>>
>>Family Name Age Level >>-------------------------------- >>01 xxxxxxxx 15 1 >>02 xxxxxxxx 15 1 >>03 xxxxxxxx 13 1 >>01 xxxxxxxx 17 2 >>03 xxxxxxxx 18 2 >> >>>>
>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