提取10到20的数据纪录的SQL语句怎么写

就是提取其中一部份纪录,用游标吗?
2024-11-29 16:46:08
推荐回答(4个)
回答1:

select *
from <列名>
between 10 and 20;

回答2:

select top 20 * from table where id not in (select top 10 id from table)

回答3:

select top 20 id from table where id not in (select top 10 id from table)

回答4:

select top 20 id from table where id not in (select top 9 id from table)