select top 10 a from tableA where id not in(select top 2*10 id from tableA where a>1 order by id) and a>1 order by id
posted on 2008-07-02 16:58  yhb199  阅读(192)  评论(1编辑  收藏  举报