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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.