Select cities with the same name in different states

Question

I have the table (result of a query) with the cities and their respective state...

... now only display cities with equal names and different states:

How do I command?

Answer 1

It would be something like this, first you take only the ones that have more than one recurrence in the table, and then you do a query by name, as you did not know the name of your table just replace the tag [sua_tabela] by table name and test:

SELECT
    *
FROM [sua_tabela]
WHERE cidade = (
SELECT
    cidade
FROM 
(SELECT 
    COUNT(*) AS qtd,
    cidade
from [sua_tabela]
GROUP BY cidade
HAVING qtd > 1) as aux);