SQL Server 20002005 常用sql查询整理

    xiaoxiao2021-03-25  76

    分页查询

    SELECT TOP 页大小 * FROM table1 WHERE id NOT IN ( SELECT TOP 页大小*(页数-1) id FROM table1 ORDER BY id ) ORDER BY id
    转载请注明原文地址: https://ju.6miu.com/read-18517.html

    最新回复(0)