Unless TOP or for xml is also specified, the order by clause is in the view, inline function, derived table, subquery, xmlorder
Error:
Unless TOP or for xml is also specified, the order by clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions.
As long as we add the following to the nested subquery View:Top 100 percentYou can.
For example:
Select * from (select top 100 percent * from tb order by col desc) as a order by col desc
For SQL statement query, I haven't thought about the use of TOP and ORDER BY statements for a long time.
One sentence is enough.
Select top 100 field 1 from table 1 where field 1 like '2% 'order by Field 2
Or
Select top 100 a. Field 1 FROM (select * from table 1 where field 1 like '2% 'order by Field 2) as a order by a. Field 1
Sorting of SQL query results
First, the statement is incorrect. Unless TOP or for xml is also specified, the order by clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions.
Second, to answer your question, the result is not output according to the sorting result in the subquery. The statement is as follows:
Select * from (select TOP 100 PERCENT * from table1 as a order by A. field1 DESC) newTable
The final result is equivalent
Select * from table1 AS