I need to write a select statement that will show all records that have the same "UserCode" in a table.
I have the below but it's only showing one of each duplicate. I need to list them out so it will show each user...
What would I write to show each duplicate so I can compare them.
SELECT UserCode, FirstName, LastName
WHERE UserCode is not null
GROUP BY UserCode
HAVING (COUNT(UserCode) > 1 )