Re: Find a duplicate value via SQL
In article <6tmvuu$bh8$1@news.xmission.com>, <Tim_Clifton@candle.com> wrote:
>
>Hello,
>
> This is undoubtedly a pedestrian question to some of you, but as I am
>new to SQL...... Does anyone know of a quick way to find records that
>contain duplicate values for a particular field via SQL? Or is this done
>is SPL?
This will get all the "country" records with duplicate values of
"int_prefix", any use?
select * from country where int_prefix in
( select int_prefix from country group by 1 having count(*) > 1 )
order by int_prefix
- Paul