How to find just the dups

lcfan · #1 02-05-2003, 05:55 PM

I'm new to sql.. and I have not been able to find in the books I have the answer to this question.

How do you code a select statement to pull out just the duplicate rows, based on just one field, which is not the primary key.

gusbarraza · #2 02-05-2003, 10:01 PM

SELECT nombre_cliente,count(*)
FROM clientes
GROUP BY nombre_cliente
HAVING COUNT(*)>1

monalisag · #3 02-25-2003, 04:55 AM

This will display rows which are having duplicates

select distinct * from emp a
where a.rowid < (select max(b.rowid) from emp b where b.empno = a.empno)