Link to home
Start Free TrialLog in
Avatar of chonabraham
chonabraham

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Sharath S
Sharath S
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial