Error: During executing the SQL Server Query by using Order by clause inside subquery is getting the following error:
select * from (select * from [Person].[CountryRegion] order by 1) k Msg 1033, Level 15, State 1, Line 2 The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP, OFFSET or FOR XML is also specified.
We are using order by in subquery, we can do the alternative by placing order by clause in outside query as:
select * from (select * from [Person].[CountryRegion]) k order by 1