I have data in myTable1 like the above.
data in myTable1
Record (4) and record(6) has same value "german"
"German" is doubling values.
I should remove one of german or modify one of german to another new country.
So I like to check doubling values.
I can check doubling value by finding the same country value is existed in another record while a query is turning in server language(in my case ColdFusion).
But I want to know that there is a database(SQL) way to find doubling values?
The code below doesn't work correctly, but it will show what I want.
select id, country
where any doubling values
order by id
that's two threads in the same day on the same problem
2009 is off to a great start :)