Select Distinct names.xyz From nameList names LEFT JOIN nameList idNum ON idNum.xyz > names.xyz AND idNum.xyz IS NOT NULL WHERE idNum.xyz IS NULL