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  阅读(137)  评论(0编辑  收藏  举报