oracle删除前一百行数据

Question

delete table yw_pjjl
 where pjjl_id in (SELECT pjjl_id
                     FROM yw_pjjl
                    where pjqd_dm = 'Y'
                      and rownum <= 100000)

表明无效，大佬们怎么解决呀

Answer 1

delete table yw_pjjl  应该是 delete from  yw_pjjl 吧，其他的应该没问题