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