trying to get the non-distinct values to show in a result set

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?
chonabrahamAsked:
Who is Participating?
 
SharathConnect With a Mentor Data EngineerCommented:
This displays the duplicated values.
SELECT shrpe FROM shr GROUP BY shrpe HAVING COUNT(*) > 1

Open in new window

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.