Tuesday, 6 January 2015

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









No comments: