sql duplicate rows from concatenated columns
Posted on 2014-11-17
I have a table with 2 columns, code and country. Code is 9 characters. I would like to find all the rows in the table where the first 8 char plus the country are duplicates.
would have concatentated values
which has the duplicate value 12345678AG
so I want to get only the records where the concatenated values are duplicated.
I have used concatenation only to describe the problem.
I am fine if the solution can select these same record without concatenation.