Getting duplicate entries 1

[Gatorajc]

What would the query be for getting a duplicate entry.

ID DOCID DRFNAME DRLNAME
1 JSMITH Joe Smith
2 JSMITH Joe Smith
3 TJONES Thomas Jones


I just want the JSMITH's

Thanks in advance

AJ


Do you feel lucky?

 

[dnoeth]

select docid, count(*)
from mytable
having count(*) > 1


or if you want the detail rows, too:


select * from mytable
where docid in
(select docid
from mytable
having count(*) > 1
)


Dieter