select top 15 * from (select top 15 * from (select top 15 * from MenuInfo where 1=1 order by OrderIndex Asc,ID Asc) tp1 order by OrderIndex Desc,ID Desc) tp2 order by OrderIndex Asc,ID Asc
这样的3层嵌套有什么作用
select top 15 * from (select top 15 * from (select top 15 * from MenuInfo where 1=1 order by OrderIndex Asc,ID Asc) tp1 order by OrderIndex Desc,ID Desc) tp2 order by OrderIndex Asc,ID Asc
这样的3层嵌套有什么作用