mysql分页

复制代码
SELECT 
        _t.id
        FROM 
        (
            SELECT 
            l.id AS id
            FROM 
            t_gnzl_log l 
            WHERE 1=1
            AND l.`plat` = 1
            AND l.`shop` = 1
            AND l.`agencyCode` = ''
            ORDER BY l.`createTime` DESC
        ) AS _t 
        JOIN (
            SELECT 
            _l.id AS id
            FROM 
            t_gnzl_log _l
            WHERE 1=1
            AND _l.`plat` = 1
            AND _l.`shop` = 1
            AND _l.`agencyCode` = ''
            ORDER BY _l.`createTime` DESC
            LIMIT 0,2
        ) t 
        ON 
        _t.id = t.id
复制代码

 

posted @   稚语希听  阅读(112)  评论(0编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示