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

Ofcourse, with a bit more coding work.

The above query uses Recursive CTE (not just CTE), we can write logic using WHILE or CURSOR to achieve the same.

---

Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.