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