N到M条记录代码,MSSQL代码库,德仔网

代码语言
代码分类
【MSSQL】 N到M条记录
作者:Dezai.CN / 发布于2011/8/9/ 898
<div><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">SQL Server：</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">Select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">TOP</span><span style="color: rgb(0,0,0)"> N </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">From</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">TABLE</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">Order</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">By</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(255,0,255)">NewID</span><span style="color: rgb(0,0,0)">() 
</span><span style="color: rgb(0,0,0)">
</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">开头到N条记录</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">Select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">Top</span><span style="color: rgb(0,0,0)"> N </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">From</span><span style="color: rgb(0,0,0)"> 表

</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">N到M条记录(要有主索引ID)</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">Select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">Top</span><span style="color: rgb(0,0,0)"> M</span><span style="color: rgb(128,128,128)">-</span><span style="color: rgb(0,0,0)">N </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">From</span><span style="color: rgb(0,0,0)"> 表Where ID </span><span style="color: rgb(128,128,128)">in</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,0,255)">Select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">Top</span><span style="color: rgb(0,0,0)"> M ID </span><span style="color: rgb(0,0,255)">From</span><span style="color: rgb(0,0,0)"> 表) </span><span style="color: rgb(0,0,255)">Order</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> ID </span><span style="color: rgb(0,0,255)">Desc</span><span style="color: rgb(0,0,0)">

</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">选择10从到15的记录</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">top</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">5</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> (</span><span style="color: rgb(0,0,255)">select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">top</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,0,0); font-weight: bold">15</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">from</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">table</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">order</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> id </span><span style="color: rgb(0,0,255)">asc</span><span style="color: rgb(0,0,0)">) A order </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> id </span><span style="color: rgb(0,0,255)">desc</span><span style="color: rgb(0,0,0)"> 

</span><span style="color: rgb(0,128,128)">--</span><span style="color: rgb(0,128,128)">N到结尾记录</span><span style="color: rgb(0,128,128)">
</span><span style="color: rgb(0,0,255)">Select</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">Top</span><span style="color: rgb(0,0,0)"> N </span><span style="color: rgb(128,128,128)">*</span><span style="color: rgb(0,0,0)"> </span><span style="color: rgb(0,0,255)">From</span><span style="color: rgb(0,0,0)"> 表Order </span><span style="color: rgb(0,0,255)">by</span><span style="color: rgb(0,0,0)"> ID </span><span style="color: rgb(0,0,255)">Desc</span><span style="color: rgb(0,0,0)">
</span></div>
试试其它关键字
　N到M条记录　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)