Hi guys,

for implementing a search possibility I need a criteria query which result set only contains duplicate entries, but only one time.

example in sql:
select * from <table> group by id having count(*) > 1

Maybe someone could give me an hint?

greets