DB Development Interview Question:

How to find the duplicate rows count from employees table in oracle?

Submitted by: Administrator

select employee_id, count(*) from employees group by
employee_id having count(*) > 1
Submitted by: Administrator