Thanks Borislav,
I have tried this but it seems to return the whole table and not rows with duplicate serial numbers.
I will try modifiying this and see where I get.
Hi,
I am working on a program where I need to return every row that contains a duplicate serial number.
I have this working but it only returns the serial number and the count where as I need to return each row that the duplicate appears on.
I have been informed I need to join this query back...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.