My actual table has diff columns .. just sum of the columns needed for
my query are used.


select asset_id, content_title, asset_level
from asset_temp
where content_title not in
(select t.content_title from asset_temp t where t.asset_level =
'E') and
asset_level = 'P'
union
select asset_id, content_title, asset_level
from asset_temp
where asset_level = 'E'