SQL statement Nesting order BY is not valid

Selec * FROM (select top to Concentrator ORDER by ordinal ASC) Order BY ordinal desc) Order by ordinal ASC

The basic idea of this code is to search the first 100 rows in the table, and then put the 100 rows in reverse order to get 第81-100 rows of data, but at this point is reversed, and then the result in ascending order, the result indicates that this statement is invalid

(solution)

select  * from     ( SELECT TOP 20                      *            FROM       (  select top 100                                   *                        FROM      Concentrator                         ORDER BY   Serial Number  ASC                      )  a            order by   serial number  DESC         )  a order  BY  Serial  ASC

To add an alias

SQL statement Nesting order BY is not valid