就是改一下SQL,配合TOP和子查询,只查询想要的部分select top 30 col1,col2...
from yourtable
where KEYCOL Not in
(select top 30 KEYCOL form yourtable
orderby sortorder
)
order by sortorder
from yourtable
where KEYCOL Not in
(select top 30 KEYCOL form yourtable
orderby sortorder
)
order by sortorder
2,建索引
3,活用Top