select state from statetable ,count(*) group by state having count(*) > 1
select statecode, state from statetable where state not in ()
SELECT DISTINCT statecode, state FROM 'table'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)