Thanks Luis. now only Months are calculatiing.

this is an example. I have a similar situation. When i use the Month Difference it also taking the Dates in to considerations os the results are comming as decimals.

This...

I am only Concerned on this

SELECT 1, 'ABC', '12B', '13B', '14B', '15B', '16B', '17B' FROM dual

UNION ALL

SELECT 2, 'BBC', '10V', 'VCF', 'BB', NULL, NULL, NULL FROM dual

UNION ALL

SELECT 3,...

Thanks this example works perfectly...But This is an example i have provided but in real life we have table and columns names.

Can you give me this as columns names with...

Thanks Pro this Is understandable.

I hope this will work in my Actual Example.

Thanks For you Time.

this logic will only apply if there are only 2 matching rows.

If there are multiple i cannot get the match.

Min and Max doesn work for the 2nd Example.