is your cycle number ascending numeric
..if so select my,column,list, max(cycleno) from mytable where aircraftid=blah
is your battery usage time satmped
...if so select top(1) batteryuse from mytable