select top 1800 * from AJ_AQJDSB
where id >(
 select max(id) from (select top 2000 id from  AJ_AQJDSB order by id) b)
 

select top 1800 * from AJ_gcxx where id not in (select top 2000 id from AJ_gcxx order by  id) order by  id


select top 1800 * from ( select top 3800 * from  AJ_AQJDSB) a  order by id desc

posted on 2010-03-18 16:55  新郎  阅读(698)  评论(0编辑  收藏  举报