alekya.kondam (9/10/2013)

---

HI ,

select * INTO Test FROM

(

select ROW_NUMBER()over(partition by customer order by customer) as counts ,customer,Contract

from tablename

) A where counts > 1

Select * from tablename where customer IN(SELECT customer from Test )

Hope it helps 🙂 🙂