SELECT *

FROM MyTable WHERE prj_code IN

(

SELECT prj_code

FROM MyTable

WHERE demo_code = 'DE1' and demo_vchar_data = 'U'

INTERSECT

SELECT prj_code

FROM MyTable

WHERE demo_code = 'RAP' and demo_vchar_data = 'YES'

)

AND demo_code IN ('DE1','RAP') AND demo_vchar_data IN ('U','YES');