SQL Interview Question - What is a Merge Join in SQL Server?

I am trying to make the concepts easier for myself and others around me to understand and visualize and remember and revise the SQL topics before an interview.

[robh]

Thanks for the video but I’m a little confused. I thought that merge joins rely on equijoins. Your presentation shows the contrary. Could you please clarify?

[venkatrayudu]

Hi you used equi join in query but merge join will be applicable to non equi join can you calrify