1 頁 (共 1 頁)

SQL 2000 limit

發表於 : 2018-05-29 22:16:38
yehlu
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)