Thanks for your reply,

Is there any possiblity with any corelated query or subquery not by assinging to a variable