看看這個,可能會有幫助: SELECT departmentId, departmentName FROM(SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNumber, C.RowNumber AS RowLimit, B.Unamed_1 AS departmentId, B.Unamed_2 AS departmentName FROM [WhatEverTableItIs] AS BINNER JOIN ( SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNumber, Unamed_1, Unamed_2 FROM [WhatEverTableItIs]) AS C ON C.Unamed_1 = 'departmentID' AND C.Unamed_2 = 'departmentName') AWHERE RowNumber > RowLimit 它將在departmentID作為Unamed_1和departmentName作為Unamed_2的行上連接表本身。它計算行號并將其用作鍵(就像主鍵一樣),然后過濾行號小于我們加入表的特定行號的行。