Re: SQL query / find duplicate records
Ian Clark <ian@tubeway-army.demon.co.uk> wrote in article
<34d71c11.948893931@news.demon.co.uk>...
> Hi All,
> I am trying to determine what records are duplicated in a table.
> select count ( distinct accnum ) from nlmst> returns 1138 rows, however;
> select count (*) from nlmst> returns 1170 rows.
> How do I find the records that are duplicated?
> Cheers, Ian.
> Tedious 'office speak' part 3: "Let's go scuba in the think tank."
>
try this
select accnum, count(*)
from nlmst
group by accnum
having count(*) > 1
--
Manuel Daponte
mdaponte@prtc.net