select * from ( select top 10 ATTL, ADC# from ( select top 10 ATTL, ADC# from Where ATTL Like 'CAT%' order by ATTL DESC) as DT1 order by ATTL ASC ) as DT2 order by ATTL DESC