1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | --簡(jiǎn)單SQL語句實(shí)現(xiàn)分頁效果，每頁100行--前三頁select top 300 * from tsendresult order by fid--第一頁select top 100 * from tsendresult order by fid--第二頁select top 100 * from tsendresult where fid not in (select top 100 fid from tsendresult order by fid) order by fid--第三頁select top 100 * from tsendresult where fid not in (select top 200 fid from tsendresult order by fid) order by fid |
聯(lián)系客服
