Hi ,
Im having the query like as below
with t as ( select 'Approved' as "Code" from dual union all
select 'Historically Relevant' from dual union all
select 'In Progress' from dual union all
select 'Internal Review' from dual )
select "Code" from t where "Code" in ('Approved,Historically Relevent')
in this i need the output like below . ie, what are the things i have selected in where clause based on that the output need to come
'Approved,Historically Relevent'
Thanks in Advance ...