SELECT * FROM(SELECT ROW_NUMBER() OVER (ORDER BY Stime ASC) AS [ORDER],A.Id,A.ClassId,A.Sname,A.DevelopersNo1 FROM xbls_SORT A WHERE (A.SmNrType=0 OR A.SmNrType=2) AND A.BShow=1 AND A.Menus=1 AND A.ClassID={#Sm:ClassId/})_TNZ WHERE _TNZ.[ORDER] > 0 AND _TNZ.[ORDER]<= 20

返回首页