sqlServer 查询表中31到40的记录，考虑id不连续的情况

<span> 1</span> <span>//</span><span>第一种：</span>
<span> 2</span> <span>select</span> * <span>from</span>
<span> 3</span>  (<span>select</span> ROW_NUMBER() over(order by Id asc) <span>as</span> num,* <span>from</span> UserInfo)<span>as</span><span> u
</span><span> 4</span>  <span>where</span><span> u.num
</span><span> 5</span> <span> between
</span><span> 6</span>  <span>10</span>*(<span>4</span>-<span>1</span>)+<span>1</span>
<span> 7</span> <span> and
</span><span> 8</span>  <span>10</span>*<span>4</span>
<span> 9</span> <span>//</span><span>第二种：</span>
<span>10</span> <span>select</span> top <span>10</span> * <span>from</span><span> UserInfo 
</span><span>11</span> <span>where</span> Id not <span>in</span>
<span>12</span> (<span>select</span> top (<span>10</span>*<span>3</span>) id <span>from</span><span> UserInfo order by Id)
</span><span>13</span> order by Id