當子查詢記憶體在ORDER BY 字句時查詢會報錯

問題：當子查詢記憶體在ORDER BY 字句時查詢會報錯

SQL:

SELECT * FROM (

　　SELECT * FROM USER ORDER BY USER_CORD

) S.

 

解決辦法：在子查詢SQL語句SELECT 後加 TOP 100 PERCENT (查詢出前百分比為100的資料，也就是查詢出全部資料)

SQL:

SELECT * FROM (

　　SELECT  TOP 100 PERCENT  * FROM USER ORDER BY USER_CORD

)