Got it Thanks every 😎 :hehe: 😉 😛 😀 🙂

select distinct t1.*,T2.* from Table_1 t1 inner

join Table_1 t2 on t1.routeno=t2.routeno

where (t1.stop='A' ) and (t2.stop='E')

and t2.stopno>t1.stopno

order by t1.routeno

select distinct t1.*,T2.* from Table_1 t1 inner

join Table_1 t2 on t1.routeno=t2.routeno

where (t1.stop='D' ) and (t2.stop='E')

and t2.stopno>t1.stopno

order by t1.routeno