SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by T.tmId desc)AS Row, T.* from sjtm T WHERE TeacherId='2220292003' ) TT WHERE TT.Row between 0 and 10
用的字查询和开窗函数
T* 是表示添加你前面要查询的所有字段, T是这个sjtm表的别名 ,其他的应该都好理解了把