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