Hi,
I have sql query like
select * from table where (case when -- then when -- then else)
Now is it possible to know which case statement is executed or is true, Because on different- different case i want to display differnt output.
If it's not possible then can you suggest me another option to do same thing in one query.
Thank you.