寻找一个SQL语句

[anycool]

写出一条Sql语句：取出表A中第32到第40记录（SQLServer,以自动增长的ID作为主键，注意：ID可能不是连续的）

不知在SQL中可取不

[paoluo]

Select TOP 9 * From TableName Where ID Not In(Select TOP 31 ID From TableName Order By ID) Order By ID

[paoluo]

Or

Select TOP 9 * From (Select TOP 40 * From TableName Order By ID) A Order By ID Desc

[十一月猪]

select top (40 - 32) * from
(
select top 40 *
from table order by id asc
) order by id desc

[Ripple_wang]

select top 9 *
from (selec top 40 * from tablename order by id)
order by id desc

[anycool]

Thank You~~~

[sharelove]

zjdyzwx(十一月猪) ( ) 信誉：100 2006-5-24 16:23:20 得分: 0



select top (40 - 32) * from
(
select top 40 *
from table order by id asc
) order by id desc



这个好像执行不了哎！