select id,name from mynumber where id in (select id from (select distinct id from mynumber) tt where rownum
文章来源:http://itercn.com/community/viewthread.php?tid=582