T-SQL to retrieve records after comparing two columns of the same table

Awesome, many thanks Sarat Babu, your reply really helped me,

Can we achieve this without CTE?

---

Please vote as helpful if my question/answer help you finding your solution.