Database-I wrote a mysql Query, but the order of the two orderby segments is different.

The first segment is non-paging & quot; selectT. ID, TName. name, (selectCount (UsingT. TID) fromUsingTwhereUsingT. TIDT. ID) asLinkCountfromTinnerjoinTNameonT. TNameIDTName. IDandTName. namelike @ tnameorderbyNameasc; (selectT. IDfromTinnerjoinTNameonT... mysql database

The first segment is non-paging.

Select T. ID, TName. name, (select Count (UsingT. TID) from UsingT where UsingT. TID = T. ID) as LinkCountfrom T inner join TName on T. TNameID = TName. ID and TName. name like @ tname order by Name asc; <= important here

The second part is paging.

Select T. ID, TName. name, (select Count (UsingT. TID) from UsingT where UsingT. TID = T. ID) as LinkCountfrom T inner join TName on T. TNameID = TName. ID where T. ID in (select ID from
   <这是加壳>
    
(Select T. ID from T inner join TName on T. TNameID = TName. ID and TName. name like @ Tname order by Name asc <= Here limit @ start, @ count) as x );
    <这是加壳> 
    
   

But is the order of the two results after order by different? Strange

<顺便网友们在帮帮忙，评评我这第二段，效率是上升还是下降？本人新手>