I have following query. It has performance issue. I need to improve the performance of this query. I need to rewrite this sub-query section to improve the performance of this query.
Anyone please give me some idea how to rewrite this subquery.
Thank you very much for your help.