esc order by sql code 序号 clas 基础 top des
- selec * from (select top 20 * from (select top 100 * from Concentrator order by 序号 asc) order by 序号 desc) order by 序号 asc
要加别名
- SELECT *
- FROM ( SELECT TOP 20
- *
- FROM ( SELECT TOP 100
- *
- FROM Concentrator
- ORDER BY 序号 ASC
- ) a
- ORDER BY 序号 DESC
- ) a
- ORDER BY 序号 ASC
SQL语句嵌套 order by 无效
来源: http://www.bubuko.com/infodetail-2354451.html