執(zhí)行sql語(yǔ)句:

select * from (

select * from tab where ID>20 order by userID desc

) as a order by date desc

邏輯上看著挺對(duì) 但是報(bào)錯(cuò):

除非另外還指定了 TOP 或 FOR XML，否則，ORDER BY 子句在視圖、內(nèi)聯(lián)函數(shù)、派生表、子查詢和公用表表達(dá)式中無(wú)效。

只要我們?cè)谇短鬃硬樵円晥D里面加入: top 100 percent 即可

select * from (

select?top 100 percent?* from tab where ID>20 order by userID desc

) as a order by date desc