用SQL语句显示一个表（有数据100行）中第30行到第40行的数据

select * from (select top 40 主键 from table1) as a where not exists(select top 30 主键 from table1 b where a.主键=b.主键 )

top 40 * from
top 30 * from
这样写

不行,好象没有数据出来.

应该对表进行排序

select * from (select top 40 * from table1) as a where not exists(select top 30 * from table1)

没主键的话,这样的问题可能会出现问题.有主键就好办

select top 10 * from t where primary_key not in(select top 30 primary_key from t)

[此贴子已经被作者于2007-4-10 14:57:31编辑过]