if u want the get number of repeated record in your table, write this query:-
IE_Visitdetail
select Visit_ID from IE_Visitdetail group by Visit_ID having count(Visit_ID)>1
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:
Post a Comment