Extracting the NON unique rows 1

[JavaSprout]

I have a location table with fields:

loc_key
country_key
unique_loc_name

I eventually want to create a unique index on country_key + unique_loc_name, but at the moment the unique_loc_name is not unique for a given country_key! So, I need to dig out all those rows which are not unique.

So, how do I extract all the rows where there are duplicate rows matching country_key and unique_loc_name?

Thanks!


Hugh Prior
webmaster

http://www.localpin.com

Regional Search Engine

 

[KarveR]

select unique_loc_name,country_key,count(unique_loc_name) from YOUR_TABLE group by unique_loc_name having count(unique_loc_name) > 1 ______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.