+----------+------------+ | name | code | +----------+------------+ | Fluffy | 000 | | Claws | 217 | | Buffy | 598 | | Fang | 000 | | Bowser | 687 | | Chirpy | 587 | | Whistler | 258 | | Slim | 298 | | Fluffy | 168 | +----------+------------+
SELECT name, code FROM MyTable m WHERE code<>0 OR (SELECT COUNT(code) FROM MyTable t WHERE m.name = t.name)=1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)