SQL - UPDATE ORDER BY 的資訊

DECLARE @TOP AS INT SET @TOP = 2 UPDATE OffLineMsg SET process = 0 WHERE ID IN ( SELECT TOP(@TOP) ID FROM OffLineMsg WHERE USERID = 'QBO00000001' ORDER BY CDATE DESC ); 上面就是只UPDATE OffLineMsg 中符合條件且ORDER BY CDATE DESC後的 前2筆資訊