摘要:
1.分页方案一:(利用NotIn和SELECTTOP分页)语句形式:SELECTTOP10*FROMTestTableWHERE(IDNOTIN(SELECTTOP20idFROMTestTableORDERBYid))ORDERBYIDSELECTTOP页大小*FROMTestTableWHERE(IDNOTIN(SELECTTOP页大小*页数idFROM表ORDERBYid))ORDERBYI... 阅读全文
posted @ 2008-06-14 12:17
涂文瀚
阅读(524)
评论(0)
推荐(0)
浙公网安备 33010602011771号