Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Return Count when greater than 1.

583560Jun 17 2007 — edited Jun 19 2007
I need queries such as select count(1), emplemail from client_dataset_detail group by emplemail; to only return rows where count(1) is greater than 1. I'm looking for duplicate values in a set of rows. How can I do that?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2007
Added on Jun 17 2007
3 comments
17,600 views