I know in a data set that I have two values (title shrpe) equal in value (16) to each other because I ran the following:
SELECT COUNT(shrpe) FROM shr; /* this gives 10
SELECT COUNT(DISTINCT shrpe)AS 'Different PEs' FROM shr; /* this gives 8
Now, how do I get the 2 shrpe values that are the same to show in a result set? What's the query structure for that?