How can i use rownumber () here?

Question

I have this table

Id cityName customer
1. Madrid. David
1. Madrid. Silva
1. Madrid. Mariya
2. Istanbul. Adi
3. Rome. Dina
3. Rome. Pedro
3. Rome. Dani
3. Rome. Indira
4. Chicago. Sally
4. Chicago. Ashtone

But i want to have this

Id cityName
1. Madrid
2. Istanbul
3. Rome
4. Chicago

Can do you know the answer

Answer 1

Do you want to remove the duplicate rows from the table? I couldn’t actually get your question.

Answer 2

I want them to insert in a table