Re: Rows with duplicate values.

From: Tom Zamani <tomz_at_redflex.com.au>
Date: Wed, 8 Mar 2000 16:59:52 +1100
Message-ID: <8a4qo1$hn$1@perki.connect.com.au>

eg table emp
empid number
empname)

delete from emp a where a.rowid <(select max(rowid) from emp where empid=a.empid and empname=a.empname)

Good luck

rob nelson <nelsons_at_bentonrea.com> wrote in message news:8a4f8p$lql$1_at_starlifter.bentonrea.com...
> We have a warehouse application that allows employee identity to be
> duplicated. I need to detect when this occurs. Is there a SQL syntax for
>
> SELECT employeeid where rowcount(employeeid) > 1
>
> ?
>
>
Received on Tue Mar 07 2000 - 23:59:52 CST