SELECT
item.Po_no
,item.Item_no
,item.comp_no
FROM
( select t.PO_NO, t.ITEM_NO, t.COMP_NO,
count(t.coMp_no) over (partition by t.PO_NO,ITEM_NO order by PO_NO ) pp
from tbpo_comp t
where t.COMP_ID='YEA' AND T.CC_ID='TEST01'
)item
where item.pp <>1
*********************************************************
记忆法大全(数百万字文字,共3张音频、视频教学光盘)
http://shop33212326.taobao.com/
*********************************************************