0

How can i use rownumber () here?

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

29th Apr 2020, 6:21 AM
Hamed Niazmand
Hamed Niazmand - avatar
2 ответов
0
Do you want to remove the duplicate rows from the table? I couldn’t actually get your question.
29th Apr 2020, 5:34 PM
Arb Rahim Badsa
Arb Rahim Badsa - avatar
0
I want them to insert in a table
30th Apr 2020, 12:36 AM
Hamed Niazmand
Hamed Niazmand - avatar