>>
>>select T.myFields from myTable T inner join (select top N PkField from myTable
>> where myCondition order by myField) X on T.PkField = X.PkField