sqlÓï¾ä·ÖÒ³ - MS-SQL Server / »ù´¡Àà

ÕâÑùµÄsqlÓï¾ä£º
SELECT TOP 20 * from fz_sk_jbdata  
  WHERE (operate_id >  
  (SELECT MAX(operate_id)  
  from (SELECT TOP 20 * 5 operate_id  
  from fz_sk_view_dlsk  
  ORDER BY operate_id) AS T))  
  ORDER BY operate_id

Ìáʾ20 * 5 ´¦ÓдíÎó£¬Ôõô»ØÊ°¡

---

SQL code:
SELECT TOP 20 * from fz_sk_jbdata
WHERE (operate_id >
(SELECT MAX(operate_id)
from (SELECT TOP (20 * 5) operate_id
from fz_sk_view_dlsk
ORDER BY operate_id) AS T))
ORDER BY operate_id
2005µÄ¿ÉÒÔ¼ÓÉÏÔ²À¨ºÅ½â¾ö£¬2000µÄ¾Í¶¯Ì¬Æ´´®£¬ÓñäÁ¿ÊµÏÖ°É

---

SQL code:
SELECT TOP 20 * from fz_sk_jbdata
WHERE (operate_id >
(SELECT MAX(operate_id)
from (SELECT TOP (20 * 5) operate_id
from fz_sk_view_dlsk
ORDER BY operate_id) AS T))
ORDER BY operate_id

---

ÒýÓÃ

SQL code
SELECT TOP 20 * from fz_sk_jbdata
WHERE (operate_id >
(SELECT MAX(operate_id)
from (SELECT TOP (20 * 5) operate_id
from fz_sk_view_dlsk
ORDER BY operate_id) AS ¡­¡­

---

se