分页显示,不只Sybase只不只支持子查询。MS SERVER肯定可以第一页 SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 10 * FROM TABLE1) AS A ORDER BY id DESC) AS B ORDER BY id ASC第二页SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 * FROM TABLE1) AS A ORDER BY id DESC) AS B ORDER BY id ASC
SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 10 * FROM TABLE1) AS A ORDER BY id DESC) AS B ORDER BY id ASC第二页SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 20 * FROM TABLE1) AS A ORDER BY id DESC) AS B ORDER BY id ASC
你这种做法页数越大就越慢,到最后就又动不了了。