Check out example codes for "t-sql get duplicate rows". It will help you in understanding the concepts better.

Code Example 1

SELECT [CaseNumber], COUNT(*) AS Occurrences
FROM [CaseCountry]
GROUP BY [CaseNumber]
HAVING (COUNT(*) > 1)

Learn ReactJs, React Native from akashmittal.com