T tandxu Unregistered / Unconfirmed GUEST, unregistred user! 2008-08-27 #3 select top M * from (select top 1 N from table order by ID desc)<br>取第M条到第N条
Z znj_326 Unregistered / Unconfirmed GUEST, unregistred user! 2008-08-27 #4 如果有唯一主键，那就好办，<br>select top 1 * from YourTable where 唯一主键 not in(select top 1 唯一主键 from YourTable) ／／这是第二条<br>select top 1 * from YourTable where 唯一主键 not in(select top 2 唯一主键 from YourTable) ／／这是第三条
如果有唯一主键，那就好办，<br>select top 1 * from YourTable where 唯一主键 not in(select top 1 唯一主键 from YourTable) ／／这是第二条<br>select top 1 * from YourTable where 唯一主键 not in(select top 2 唯一主键 from YourTable) ／／这是第三条
