SELECT MAX(DECODE(COL,'1',CODE,'')),MAX(DECODE(COL,'2',CODE,'')) FROM (
SELECT CODE,LNAME,CNAME,PROGUNIT,ROW_NUMBER() OVER(PARTITION BY PROGUNIT ORDER BY PROGUNIT) COL FROM ORDTY WHERE PROGUNIT='SMP')
posted on 2009-07-08 21:55
譚明 閱讀(249)
評(píng)論(0) 編輯 收藏 所屬分類:
Oracle