from Shopping where pfl = 2 and pname=any(select pname from (select pname from Shopping order by pworkoff desc) where rownum<7)
这个没有人会吗。。。。