select top 5 *
from MS_DEPART_RELATION
where
data_id not in (select top 6 data_id from MS_DEPART_RELATION order by data_id)
order by data_id
含义:从tableName表中检索从第6条开始的5条记录
select top 5 *
from MS_DEPART_RELATION
where
data_id not in (select top 6 data_id from MS_DEPART_RELATION order by data_id)
order by data_id
含义:从tableName表中检索从第6条开始的5条记录