select top 20 * from source where id not in (Select top 40 [id] from source where cot='756' and s_date between '2006-12-23' and '2006-12-25' and memo='成功')
try: select top 20 * from (select * from source where id not in (Select top 40 [id] from source order by id))a where cot='756' and s_date between '2006-12-23' and '2006-12-25' and memo='成功'
select top 20 * from (select * from source where id not in (Select top 40 [id] from source order by id))a where cot='756' and s_date between '2006-12-23' and '2006-12-25' and memo='成功'