好几次参加笔试都遇到了这个问题,可是每次都答得不好.唉,看来自己不会总结啊.
select top 10 from table where id not in (select top 20 from table order by id) order by id
好几次参加笔试都遇到了这个问题,可是每次都答得不好.唉,看来自己不会总结啊.
select top 10 from table where id not in (select top 20 from table order by id) order by id