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