摘要:
分页方案一:(利用Not In和SELECT TOP分页) 语句形式: SELECT TOP 10 * FROM TestTable WHERE (ID NOT IN (SELECT TOP 20 id FROM TestTable ORDER BY id)) ORDER BY ID SELECT TOP 页大小 * FROM TestTable WHERE (ID NO... 阅读全文
posted @ 2009-02-20 16:38
ToKens
阅读(733)
评论(0)
推荐(0)
浙公网安备 33010602011771号