用一条SQL语句取出第 m 条到第 n 条记录的方法 取出 记录 –从Table 表中取出第 m 条到第 n 条的记录：(Not In 版本) SELECT TOP n-m+1 * FROM Table WHERE (id NOT IN (SELECT TOP m-1 id FROM Table )) –从TABLE表中取出第m到n条记录 (Exists版本) SELECT

用一条SQL语句取出第 m 条到第 n 条记录的方法

取出 记录 <style> .CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;} .CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;} .CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li

a{color: #333;padding: 3px 10px;} .CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;} .CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;} .CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;} </style> <!—ecms

–> <!—ecms
• $velocityCount

–> <!—ecms

–>

 --从Table 表中取出第 m 条到第 n 条的记录：(Not In 版本)    SELECT TOP n-m+1 *   FROM Table   WHERE (id NOT IN (SELECT TOP m-1 id FROM Table ))      --从TABLE表中取出第m到n条记录 (Exists版本)    SELECT TOP n-m+1 * FROM TABLE AS a WHERE Not Exists  (Select * From (Select Top m-1 * From TABLE order by id) b Where b.id=a.id )   Order by id    --m为上标，n为下标,例如取出第8到12条记录,m=8,n=12,Table为表名,Temp为临时表   Select Top n-m+1 * From Table   Where Id>(Select Max(Id) From   (Select Top m-1 Id From Table Order By Id Asc) Temp)   Order By Id Asc  --找出升序的第m到第n条记录,更为笨拙的办法是  Select * From   (Select Top n-m+1 * From (Select Top n * From 表名 Order By id Desc) t1 Order By id) t2   Order By id 

喜欢 (0)赏

[搞代码]

分享 (0)