Return records where column2 contains different values with column1 having the same value 1

[jasonhuibers]

Name column:
Height column

Name column contains the same value but the Hight column is different.

IE:
NAME HEIGHT
John 6FT2
John 6FT2
Shawn 3FT1
Shawn 5FT2

Return SHAWN as Shawn contains multiple records with a different Height value

 

[carp]

You might try a nested query:

The inner query will find all of the distinct combinations:

SELECT DISTINCT name, height FROM myTable;
This will give you
John 6FT2
Shawn 3FT1
Shawn 5FT2

The outer query will find the names with multiple heights:

SELECT name
FROM (inner query)
GROUP BY name
HAVING count(*) > 1;

This will give you Shawn.