分页查询

SELECT * FROM(
    SELECT TOP 5 * FROM(
        SELECT TOP (4*5) * FROM Print_order ORDER BY Order_keyID ASC) 
            AS TEMP1 ORDER BY Order_keyID DESC)
        AS TEMP2 ORDER BY Order_keyID ASC

  

posted @ 2015-08-26 21:00  每天进步一点点!  阅读(161)  评论(0编辑  收藏  举报