ÇëÎÊÒ»¸ö¼òµ¥µÄSQLÓï¾äÎÊÌâ¡£

ÎÒÏ뽫һÕűíÖеÄÊý¾Ý·ÖÅú¼ÓÔØ¡£
ÀýÈçµÚÒ»´Î¼ÓÔØÕâÕűíµÄÇ°1000Ìõ¼Ç¼£¨±íÖеÄÊý¾Ý¿ÉÒÔ½øÐÐÅÅÐò£©¡£µÚ¶þ´Î¼ÓÔØ1001-2000ÌõÊý¾Ý¡£ÒÔ´ËÀàÍÆ¡£ÇëÎÊÕâÑùµÄSQLÓï¾äÓ¦¸ÃÔõôÑùдÄØ£¿

---

SELECT TOP 1000 *
from table1
WHERE id NOT IN
(
SELECT TOP 1000*(Ò³Êý-1) id from table1 ORDER BY id
)
ORDER BY id

---

SELECT TOP Ò³´óС *
from table1
WHERE id >
(
SELECT ISNULL(MAX(id),0)
from
(
SELECT TOP Ò³´óС*(Ò³Êý-1) id from table1 ORDER BY id
) A
)
ORDER BY id

---

·ÖÒ³ÓжàÖÖ˼·£¬×î¼òµ¥µÄorder by + fetch/top£¬·ÖÒ³ÌáÈ¡

---

ÒýÓÃ

SELECT TOP 1000 *
from table1
WHERE id NOT IN
          (
          SELECT TOP 1000*(Ò³Êý-1) id from table1 ORDER BY id
          )
ORDER BY id

not in Ö´ÐÐЧÂʲ»¸ß

---

ÎҾͻá23Â¥µÄд·¨£¬Ö´ÐÐЧÂʲ»¶®£¬×Ô¼ºÔÙ²é²é°É¡£

---

ÄÇÖ´ÐÐЧÂʽϸߵÄÓï¾äÊÇ£¿£¿£¿

---

newid

where isnull(left(cast(newid as varchar),len(cast(newid as varchar))-3),'0') = Ò³

---

ÒýÓÃ

SELECT TOP 1000 *
from table1
WHERE id NOT IN
          (
          SELECT TOP 1000*(Ò³Êý-1) id from table1 ORDER BY id