SQL & PL/SQL

Hi,

I am using oracle 11g.

I've a table (T1) with below data and want to insert these value into another table (T2).

CITY            STATE
--------------- --
San Francisco   CA
Palo Alto       CA
Sarasota        FL
New York        NY
Boston          NY
Boston          CO

Table 2 has a unique constraint on city and state columns.

I want to filter non-unique records before inserting data into table 2 to avoid UNIQUE Constraint exception.

so, in the above example, the query should display below records

Boston          NY
Boston          CO

any ideas?

thanks