Hi

Use this

select min(wan),max(wan),subscriber from retail group by subscriber having count(*)>1