select distinct t1.Lot,t2.Value as PROD_Value,t3.Value as ENG_Value
from TABLE1 t1
inner join TABLE1 t2 on t1.Lot = t2.Lot and t2.Mode = 'PROD'
inner join TABLE1 t3 on t1.Lot = t3.Lot and t3.Mode = 'ENG'
※ 引述《SuLaPKLa (= =)》之銘言：
: （針對 SQL 語言的問題，用這個標題。請用 Ctrl+Y 砍掉這行）
: 資料庫名稱：Oracle
: 內容/問題描述：
: TABLE1
:

many thanks