SELECt
id,
origin
FROM
My_Table T1
WHERe
EXISTS (SELECt * FROM My_Table T2 WHERe T2.id = T1.id AND T2.origin = ‘ROME’) AND
EXISTS (SELECt * FROM My_Table T3 WHERe T3.id = T1.id AND T3.origin <> ‘ROME’)
SELECt
id,
origin
FROM
My_Table T1
WHERe
EXISTS (SELECt * FROM My_Table T2 WHERe T2.id = T1.id AND T2.origin = ‘ROME’) AND
EXISTS (SELECt * FROM My_Table T3 WHERe T3.id = T1.id AND T3.origin <> ‘ROME’)
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
