SELECT DISTINCT name, city, state FROM tbl
SELECT name, city, state FROM tbl GROUP BY name, city, state
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)