SQL 2000 limit
發表於 : 2018-05-29 22:16:38
https://stackoverflow.com/questions/511 ... -from-x-to
代碼: 選擇全部
SELECT TOP 10 *
FROM MAN p1
WHERE p1.A01 not in (SELECT TOP 20 A01 FROM MAN p2)