How to get the repeated record in Table?

if u want the get number of repeated record in your table, write this query:-

  IE_Visitdetail

Visit_ID	PatID	Pat_name	VisitDate	ConsultantName

select Visit_ID from IE_Visitdetail group by Visit_ID having count(Visit_ID)>1