Hi Mark,

I figured it out myself.

Instead of using row_number() if I use rank() or dense_rank() it would take all the combinations keeping the value of RN same for the highest...

Hi Mark,

What an excellent reply. Thanks a ton. It just lacks one thing and that's because I dint explained that case in my requirement but you asked that question in...