SQL 2000 limit

[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)